Using SQL Server 10.0.2531 Management Studio, I was able to skip the updating values part.

So,

1. Design table, Add

.[Id] column as Identity seed 1 increment 1, save.

2. Right click...

See Paul S. Randal's article

It gave me better understanding of the transaction log. Seeing him and Kimberly Trip is a trip! - pun totally intended. They are great presenters; and,...

For me it is either:

1) The T-100 in terminator 3. The part were it shuts itself down, reboots, and resists the T-X reprogramming, gave me a chuckle.

2) Dr. Know...

Let's get down to it gentleman, I think Oracle sucks but I have learned to like it - sort of. It is more like a living arrangement.

In my experience Oracle...

I am missing something here: I have several DTS 2000 packages nailing Sql 2005 server/instances databases.

It is worth adding that the feature pack may break Sql Server Enterprise Manager. You...

I probably don't need to say this is a real pain in the a?? and a warning before installing the Add-In was due.

The fact that a basic MMC Manage command...

In SQL QA, there is a Scripting options... dialog shortcut to Tools>>Options>>Script tab. This is right under the Script Object to... options. It helps setting some added time saving options.

My...

In my case the service went down; just had to restarted.

Ah, well; that is true for just about anything inside the scope of a tran. I would not use truncate as part of a long tran though: that kind of...

Although I could easily be proved wrong, I was thinking implicit because i don't think anyone (experienced) intentionally will act on millions of rows - filling up the logs explicitly.

TRUNCATE...

C,

What is the compatability level on the database you are executing "dump tran with no_log" ?

You can northwind this question like this...

select

datepart(qq, orderdate) 'day of week'

, count(*)

from orders

group by

datepart(qq, orderdate)

you get...

4202

3173

2181

1274

Well i ran into a similar problem below:

Deserialization failed: The element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Textbox' has incomplete content. Expected 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Action http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Visibility http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:ToolTip http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Label http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:LinkToChild

Now, this is a good article and example of what can be done with the SQLCLR integration.

I can't help but think, it's gotta make DBAs very nervous from a...

I read this somewhere:

"Measure twice, cut once."

Learn it well; it will save your dunkey.