jay holovacs (1/26/2012)

---

Interesting concept.

My lawyer who injured his back in sports when young uses a stand up computer desk (and also sits on a large pilate? ball instead of...

Thanks Jeff. Guess the key is knowing how to use the OVER clause for something else besides ROW_NUMBER().

And that's a nifty way to get a lot of test data in...

Revenant (12/21/2011)

---

"When you create a linked or remote server, SQL Server creates a default login mapping to the public server role. This means that by default, all logins can view...

Agreed, at this point it's just a cash prize. Maybe one of the stipulations for contest could...

Yeah, it's cool; I didn't know you could do this. I was getting this type of thing done by, and I'll use the C word, a cursor. 😀

Ken

As others have said this is a really good discussion. I'm glad this article got reposted. A couple months ago we inherited a couple 2005 servers; one which was really...

Oh, true about the DROP TABLE statement. I accidently uncommented out the comment when reformatting :laugh:

Ken

sp_send_dbmail needs a profile to send a message from. I added it as a param. If null then grab a profile from a system table. Also removed the duplicate DROP...

GSquared (11/28/2011)

---

Another thing you can probably do is write a DDL trigger that tracks stored procedure creation and alteration, and which blocks creating them if they have "update" or "delete"...

Thanks a lot. I think this does the trick.

CREATE ROLE rlReportWriter

CREATE USER ReportUser FROM LOGIN test

CREATE SCHEMA ReportWriter Authorization ReportUser

EXEC sp_addrolemember db_datareader, rlReportWriter

EXEC sp_addrolemember rlReportWriter, ReportUser

GRANT CREATE PROCEDURE TO rlReportWriter

GRANT...

The single most common cause of both work overload and project failure is doing work twice. The most common cause of that is picking up some piece of work (opening...

I see it too, and I've seen it before when posting code on this site. It must be that special characters get in there instead of CRLF combinations. Try deleting...

That's one of the beauties of this...

Think I got it now after seeing it taught at PASS last week. The order in which a Select statement is deconstructed:

from

on/join

where

group by

having

select

distinct/order by/top

Which is why we can only refer...

"Use where [10%] > 1000 "

That's what I recall, that you can use aliased names in a Where or Group By clause. But this returns an error in SQL 2008.

Select...