I guess if you were just memorizing answers and not learning it would be a bad thing as you described. Assuming you have some working knowledge of the subject matter...

I'm not sure what you guys are getting all fussy about...those links and exams don't even exist on those sites. Besides what better study guide is there then a copy...

give this one a go...

-----------------------------------------------------------------------------

USE CICP

GO

IF OBJECT_ID(N'dbo.NewShippers') IS NOT NULL

DROP TABLE dbo.NewShippers

GO

CREATE TABLE dbo.NewShippers (

Phone NVARCHAR(15) PRIMARY KEY

)

GO

INSERT INTO dbo.NewShippers (Phone)

SELECT Northwind.dbo.Shippers.Phone FROM Northwind.dbo.Shippers

GO

Select into isn't the correct way to insert data if you are going to manually create the table. So in your example either create the table using the first statement...

Depending on your security setup and what version of SQL you're running you could use the good ole Bulk Copy (BCP) Utility (http://msdn2.microsoft.com/en-us/library/ms162802.aspx)

Ah okay so it's based on table statistics and index fragmentation...yeah I'm including table hints in my queries here because for some reason the clustered index on my table1 is...

The best solution I've come across is Jasper Smith's RS Scripter utility. I did this recently when I wanted to take a copy of QA and script out the entire...

So I guess the real question is...how does SQL Server choose which index to use?

Anyone...?

I've had a couple of these....

Q's:

1.) If you were a pizza topping which one would you be and why?

2.) If you could choose any state to secede from...

Que?

Thanks Peddie...I was referring to the 'Access Denied' page that pops up when clicking on the 'Active Threads' link. It appears even after logging in using the 'Login' link.

Thanks Steve,

Any chance they will be including the login and registration forms on the 'Access Denied' page?

i agree with Kenneth...whenever I need to use brackets I can't help but thinking "What idiot named this object something they we're not supposed to". I don't think it causes...

Why not just used Named Pipes?

trunacte statements are not logged so I don't believe the t-log would be affected by this. If those sp's called did delete's however it would most definitely increase the t-log...