If you typically query the Document table by PersonId, change the clustered key on the Document table to be PersonId instead and you should get great response time for individuals...

And for general performance reasons, get rid of the functions on the date/datetime column:

SELECT p.product,

SUM(CASE WHEN j.holiday = 0 THEN j.qty_delivered END) AS...

You could try:

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

If that doesn't work, there are SERVERPROPERTY parameters that aren't documented: you might try poking around for some of those and see if any of them help...

Try:

ADD (SELECT ON OBJECT::[dbo].[SecDetail] BY [dbo])

Yes there is a setting, but you should...

For me, it depends, mostly on how and/or how often the full_name was used.

Agreed.

For example:

ALTER TABLE dbo.tablename

DROP COLUMN Full_Name;

ALTER TABLE dbo.tablename

ADD Full_Name AS CAST(ISNULL(F_Name + ' ', '') + ISNULL(Lname, '') AS varchar(100))

-- change 100 to whatever max length you want for...

Jeff Moden (9/20/2012)

---

It is also possible that person wrote about themselves...

SomewhereSomehow (9/20/2012)

---

Actually it is...

GSquared (9/20/2012)

---

SomewhereSomehow (9/20/2012)

---

Nope. Not going to taint you with my personal opinions regard Mr. Celko. Too bad he is a co-author with Itzik on a book as I...

sqlguy-736318 (9/19/2012)

---

I think it's unfortunate that MS doesn't provide an automated tool to review a SS database for standards compliance. The nice thing about FXCop is that it's somewhat...

Quite true! In fact, don't start...

I think MS had that at one point but they dropped it.

In general, carefully determine rules among yourselves and

most of all, consistently follow them.

FWIW, here are my...

If you want/need EXEC() (vs sp_executesql), then you can use a temp table to return the row total:

DECLARE @sql VARCHAR(2000)

CREATE TABLE #result ( total_rows int )

SET @sql = 'DECLARE...

SQLKnowItAll (9/19/2012)

---

Here's some sample code:

CREATE TABLE #test(id int identity (1,1), filler VARCHAR(1))

GO

INSERT INTO #test(filler)

SELECT 'a'

GO 5

DECLARE @sql VARCHAR(150)

SET @sql = 'BEGIN TRAN SELECT * FROM #test SELECT * FROM...