hi everone i have question about DBCC SHOWCONTIG results of Table we have table with huge amount of data in it. When i run ...

erdem

06-16-2005 04:26 PM
Andrew J. Kelly

I try change database's collation. What is the right way to do this? Now I have script which 1) Drop indexes 2) Drop pk:s 3) Alter all character...

Major

06-16-2005 08:51 AM
David Gugick

I have one customer.dbf file and in SQL Server I have a customer table. Now the problem is that I don't have Dbase install in my computer. I want...

Roy

06-15-2005 05:21 AM
Narayana Vyas Kondreddi

Is it possible through front end like I can call DTS package on demand like on button click.. for instance on button PUSH click I want to call...

Roy

06-15-2005 05:18 AM
Narayana Vyas Kondreddi

Hi, I'm trying to migrate a database from Sybase to SQL Server. As far as I understand (I'm not a db exert), it is not possible in SQL Server...

Martin

06-14-2005 03:55 PM
Hugo Kornelis

I have one customer.dbf file and in SQL Server I have a customer table. Now the problem is that I don't have Dbase install in my computer. I want...

Roy

06-14-2005 12:52 PM
Roy

Dear guys. I want to push and pull data from SQL Server to Dbase and vise versa on demand so what would be the best way. As I thought I have to...

Roy

06-14-2005 12:37 PM
Roy

You are the DBA for a busy order entry database. You want to provide a method for automatically backing up the transaction log for you database...

Roy

06-14-2005 03:04 AM
Christian Donner

I've got VS.NET 2003 and SQL 2000 Developer installed on my notebook, but for some reason I'm having a real hard time connecting to the SQL instance....

Nick A

06-13-2005 04:16 PM
Nick A

For ORG_ID: I have the query below.. can anyone help me with it.. this is the first time I am creating SPs.. thanks in advance 1. First Join between...

Sujay

06-13-2005 02:31 PM
Sujay

If Table1 is going to be joined on 90% of the time on ID, and used to generate lists 10% of the time, which of the following combinations of indexes...

Roy

06-13-2005 02:18 PM
Hugo Kornelis

I'm wondering if there's a slower running time between IN and EQUAL in the WHERE clause. SELECT * FROM CUSTOMERS WHERE CUST_ID = 123; vs SELECT *...

XMan

06-13-2005 01:27 PM
XMan

If Table1 was used in an inner join, with the ID field being the inner join index, which of the following indexes would provide the best...

Roy

06-13-2005 12:21 PM
David Gugick

Are UNIQUEIDENTIFIER & TIMESTAMP data type are uniquly identified in the database? Thanks

Roy

06-13-2005 12:19 PM
David Gugick

I am in a situation where I need to find out unique field names with different values in a table having 200+ columns. Let's say I have two rows with...

alpoor

06-08-2005 10:35 PM
Craig Kelly

The following two SQL statements do the same updates, but the second runs 10 times faster, just by creating an intermediary temp table explicitly....

matthew c. harad

06-08-2005 11:22 AM
matthew c. harad

Hi - Does anyone know if there is a way for me to limit what port ranges SQL Server uses when clients connect to 1433? I.E., can I limit the range...

dm4714

06-07-2005 04:42 PM
dm4714

Where I can found information that what indexes are primary keys, and where is the information of constraints type in sysconstarint table? I readed...

Major

06-07-2005 05:14 AM
Siddharth Vidhani

Hi Folks, I have developed a Setup Program. I have also created an MSI, to which I make a call from within this setup program. The Point is that in...

Shailaindra Sharma

06-06-2005 07:31 AM
Sue Hoegemeier

Where can I found index_name and index_keys of indexes in SQL Server? I know that there is table sysindexes but there aren't index names etc. I need...

Major

06-06-2005 07:15 AM
Jacco Schalkwijk

Here I have a question like I have created one stored procedure which InsertCustomer and call that stored procedure in the customer form.......

Roy

06-03-2005 03:46 PM
Andrew J. Kelly

I have too many connection from one user, Can I limit this user's connectiion num? I can't change his code. Thanks Jack

microsoft

06-02-2005 03:32 PM
Mike Epprecht \(SQL MVP\)

Hi, I am experiencing a totally unexplainable date behavior, coming out of the blue, without warning, I don't understand anything any more. Let me...

bthouin

06-01-2005 05:37 PM
bthouin

Unable to understand licensing. We have a 25 user windows 2000 server as a member of windows small business Server 2003 std edition domain. We would...

Orlando

06-01-2005 02:56 PM
Jens Süßmeyer

I have a SQL2K instance that has granted me access through an unusual setup. The SQL2K instance has granted me access through BUILTIN\Administrators...

Lee Grissom

06-01-2005 01:08 PM
Lee Grissom

I have a copy of Data File and Log File, named pms_bak.mdf and pms_bak.ldf. May I restore them into my new sql server? How can I do? thank u

hui

06-01-2005 12:29 PM
Jens Süßmeyer

Hi, I am using sql server 8. I have a table with a column whose data type is set to Float with a length of 8. Whenever i am inserting the value...

Loui Mercieca

06-01-2005 07:28 AM
David Gugick

I am trying to take the backup into another machine which is on the network but failed to do so.... Like backup database Health to disk...

Joh

06-01-2005 01:43 AM
rtraman

Hi all gurus. We have an app using SQL Server 2000 (PC Side) and SQL Server CE 2.0 (PPC Side); now I'm guessing what effort should be necessary to...

Saverio Tedeschi

05-30-2005 02:08 AM
Saverio Tedeschi

One quick question....I have a MedicalCause table and it contains 12 billions of records and I wanna do partitioning that table and wanna create view...

Joh

05-29-2005 05:15 AM
John Bell

Working Fine : select top 5 * from MedicalHistory Doesn't work : select top 5 * from MedicalHistory order by 1 Doesn't work : select top 5 * from...

Joh

05-28-2005 07:25 PM
Steve Kass

Here is the quick question, i have created MedicalHistory Partitionned view and it's working pretty good.. when I write this select top 1 *...

Joh

05-26-2005 02:09 PM
David Gugick

Can any one tell me regarding the foreign key constraints like I wanna findout which columns doesn't contain the foreign key constraint so that I can...

Joh

05-26-2005 01:06 PM
Hari Prasad

USE PUBS GO CREATE FUNCTION . () RETURNS int AS BEGIN RETURN (SELECT max(len(fname)) + 1 FROM employee) END GO SELECT top 5 fname +...

Joh

05-26-2005 08:59 AM
Joh

Hi all, I'm trying to develop a Java application that will manipulate and transfer data from sql server X to sql server Y. I'm pretty new to...

inder

05-26-2005 08:42 AM
Inderjit Rai

What are the major difference b/w index hint and creating index on column Thanks

Joh

05-25-2005 07:30 AM
Vinod Kumar

bthouin wrote: The transaction must always be on the same connection. You want a transaction to run as quickly as possible, so issue if you are...

David Gugick

05-25-2005 07:26 AM
David Gugick

I am using the following query for fetching the data from the txt file..... but failed to do so.... select a.* from OpenRowset('MSDASQL',...

Joh

05-25-2005 07:06 AM
Vinod Kumar

I think my mind is going. I once new how to do this but have somehow forgotten. We have SQL 7.0 loaded and has been running for several years. Also...

InaFog

05-24-2005 06:41 PM
David Gugick

hi, i have an exisiting vs.net 2003 app that work with MSDE and/or SQL 2000 (SQL in Server A and my app in Workstation B) i would like to work with...

Rafi

05-24-2005 07:17 AM
Rafi

if we create 1000 database users then is this create adverse effect on the master database? Thanks

Joh

05-20-2005 02:49 PM
Joe Yong

Hi Whenever I run a query in enterprise mananger that contains a date against one of our SQL server databases, the regional date format on my local...

nospam@mlu035.freeserve.co.uk

05-20-2005 04:53 AM
Jacco Schalkwijk

I have a large xml file around 500 MB and I used to insert the data every day in one table, the issue is that I only want to use SQL Server to do...

Joh

05-20-2005 03:51 AM
Mike Epprecht (SQL MVP)

Can any one give me an idea like I want to use bcp + openxml command for saving the XML file data into one of mine Customer table... I have...

Joh

05-19-2005 10:50 AM
Joh

I have created two jobs.. First Job... take the full backup daily at 12:00 AM Second Job...take the log backup every 1 hour till 11:PM The question...

Joh

05-18-2005 04:04 PM
Hari Prasad

What are the maximum limitation of database user ?

Joh

05-18-2005 03:06 PM
Joh

Can any one give me some idea regarding the major difference between working in Clustering environment and Non Clustering environment with respect of...

Joh

05-18-2005 01:28 PM
Joh

Any possibility? Right now I have a 600 MB space free and on my system I have a 6 GB backup file and I want to restore it on my own system.... I...

Joh

05-18-2005 10:04 AM
David Gugick

Can we have more than one column alias for a sinle column in the select list. Something like this SELECT field1 A,B FROM Table

Gopinath S

05-18-2005 09:05 AM
Hari Prasad

I want to remove all the procedures from the cache... I used DBCC FREEPROCCACHE but doesn't effect. Any idea? Thanks in advance.

Joh

05-18-2005 08:23 AM
Joh