quote:

---

I think, I know what the dba meant.

If you create a nonclustered index and don't already have a clustered index, SQL...

Actually looking directly at the index data it does not create a clustered index. Does exactly what I stated.

First I created a table like so.

CREATE TABLE [tbl_AgentList] (

[CCID] [int] NOT...

Check out Quests "Spotlight On" http://www.quest.com

What is the SPID for each and what COMMAND state are they in?

The problem is it is order by character order because POProjects.ProjectStartDate is a varchar. This happens because the last thing that occurrs is the Order By and because you used...

Try this

declare @sqlstring nvarchar(1000), @table_name varchar(25), @cntout as int



set @table_name = 'tableA'

set @sqlstring = 'select @cntout = count(*) from ' + @table_name



exec sp_executesql @sqlstring, N'@cntout as...

It is supposed to. But I don't kno anyone who has directly tested. Your best bet is to check with AMD and see if they have tested an benchmarked (this...

You should not under any circumstance use GUIDs as a Clustered Index. The reason is the GUIDs will cause so much data shifting it will bog your server down over...

One way is to check login time on spid 1-5 in EM under Current Activity or in sysprocesses in master db in QA or EM. This is the time SQL...

I created both tables like so

CREATE TABLE customer (cust_id int, rec_fname varchar(20), rec_sname varchar(20), rec_bday datetime)

CREATE TABLE clnpers (cust_id int, rec_fname varchar(20), rec_sname varchar(20), rec_bday datetime)

put in a bit of...

The logic is this.

NOT EXISTS checks for the return of any value not what is in the value. But by taking and doing "WHERE TableA.Col1 = TableB.Col1 AND TableA.Col2 =...

Yes, I have been using the freeware product since it first came out and then ZDNet bought it and canned several of the other ferrets such a newsferret. But the...

I cheated. If you look at the link posted by Noel you will find on the first page the documents id. "ISO/IEC 9075:1992" so I use WebFerret to find "ISO/IEC...

FIrst off to ensure absolutely no duplicates create a Unique Constraint on the table that includes all columns together that must be unique such as First Name with Last Name...

Here is 99

http://www.ncb.ernet.in/education/modules/dbms/SQL99/