Viewing 15 posts - 46 through 60 (of 61 total)
~Larry Briscoe (5/21/2009)
All queries failed due to missing Owner/Schema.
The queries that were supposed to run worked fine for me.
I think a potential issue in the question that could get tricky...
May 21, 2009 at 7:30 am
Very impressive Chris, thanks for sharing this!
Regarding "... not naming stored procedures with the sp_ prefix ..." I have also, on rare occasion, placed administrative/maintenance stored procedures in the master...
May 20, 2009 at 5:47 pm
The page below (under "Scalability & Performance") gives 50 for Enterprise and 16 for Standard edition:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
I had seen the comparison above and got the question right. However,...
May 18, 2009 at 6:56 am
I'm not surprised. I've interviewed too many SQL Server "experts" and "experienced DBAs" (according to the placement firm that sent them) who couldn't name any of the system databases. When...
May 18, 2009 at 6:39 am
John Esraelo (5/16/2009)
this is also what I got from running the few lines in below: 🙁
use mssqlsystemresource
Msg 911, Level 16, State 1, Line 7
Database 'mssqlsystemresource' does not...
May 16, 2009 at 5:14 pm
Amit Lohia (5/15/2009)
I have just install SQl 2008 and I do not see a resource database in system database? Do we need to install it?
You don't need to install the...
May 16, 2009 at 2:22 pm
Very informative, I like that the events that are useful are singled out, as are those that are seldom used or deprecated. This is a very useful series, I've enjoyed...
May 15, 2009 at 5:09 pm
Thanks, I look forward to reading this!
May 15, 2009 at 6:44 am
Actually, it's the Resource database, with a capital R, not resource.
May 15, 2009 at 6:28 am
The answer's explanation has a typo, "DML" should be replaced with "DMK" for Database Master Key.
May 14, 2009 at 6:52 am
Thanks David, I'm looking forward to part 2.
Processes involving lookup tables could benefit from a solution like this. Users could undo their changes without remembering the prior value or whether...
May 11, 2009 at 7:14 am
SELECT * FROM ...
Sure this is useful for ad hoc queries, but too often it appears in production code without good reason.
May 8, 2009 at 6:03 am
Might also mention that WITH TRUNCATE_ONLY is not available in SQL Server 2008.
April 17, 2009 at 6:29 am
Two days in a row of QOD strangeness. MDX is now part of TSQL?
If I write a CLR function in C# and call it in a TSQL statement, does that...
April 14, 2009 at 9:52 am
Viewing 15 posts - 46 through 60 (of 61 total)