Read all or part of a column of a table, compute the distribution statistics, update the stats blob.

This kind of reaction is why I don't submit questions...

They're row locks. So two exclusive locks on different rows of the same index.

The promised picture

This shows about the rear 1/4 of my desk, slap in the centre (left-right).

Operations which can be minimally logged: http://technet.microsoft.com/en-us/library/ms191244%28v=sql.105%29.aspx

"Do I really have to do things the proper way?"

http://www.sqlservercentral.com/Forums/Topic1621383-2799-1.aspx

pietlinden (9/28/2014)

---

DECLARE @currMonthNum INT,

@lastDayMonth INT

SET @currMonthNum = DATEPART(MM, GETDATE())

IF @currMonthNum IN (1, 3, 5, 7, 8, 10, 12)

SET @lastDayMonth = 31

IF @currMonthNum = 2

SET @lastDayMonth = 28

IF @currMonthNum IN (4,...

Which is it?

They need to be able to query and change data, create tables, views and procs?

or

They need full control over the database?

Why are you looking in the SQL Server Reporting Services logs?

Anything from a couple minutes upward. I've seen 13 hours, I've heard of a couple of days.

Why restart? If TempDB is full, make the files larger. Interrupting everyone because you've...

Eric M Russell (9/30/2014)

---

So, if a DBA removes an end user from the DBO role in the process of performing a migration to the next release of SQL Server, and...

It's the format code. See the CAST and CONVERT page in Books Online.

Eric M Russell (9/30/2014)

---

The intent is not the deceive but rather to present a simplified version of the truth that supports one's side of an argument and avoids a longer...

Plan Explorer from SQL Sentry.

This, in an instant.