SQL University – Other Capacity Issues
This is the final lecture this week at SQL University. We are covering the topic of capacity planning this week...
2010-07-30
2,658 reads
Schedule Announced for SQLSaturday #49 in Orlando
Our schedule for this year has 47 one hour sessions plus another 6 “mini” fifteen minute presentations, plus a separate...
2010-07-30
1,377 reads
SSC Editorial: Becoming Highly Productive
This editorial is about the idea of being highly productive more than how to actually accomplish it. Most of us...
2010-07-30
1,398 reads
Schedule Published for SQLSaturday #51 in Nashville
Just released, http://www.sqlsaturday.com/51/schedule.aspx?sat=51. Five tracks, lots of good speakers, but I see a few new names too. Looks like a...
2010-07-29
1,376 reads
Poor Little Misunderstood Views
Some people love ‘em, some people hate ‘em. But, one thing I have found to be nearly universal is that...
2010-07-29
60,321 reads
Finding Key Lookups In Cached Execution Plans
Ask anyone with performance tuning experience to list the most expensive operations in an execution plan and it's a safe...
2010-07-29
5,395 reads
SQL Bits 7 – Registration is Open !
Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!
This year its in York (Sept 30th till October 2nd).
SQLBits is...
2010-07-29
1,496 reads
Pesky Protected Mode
How many of you keep falling for this one…You open up Report Manager for a user that you know you...
2010-07-29
1,491 reads
The Killer Backslash in TSQL
--it is
quite startling to see that this, in TSQL, executes.
Select \
/*
---------------------
0.00
(1
row(s) affected)
so does
this....
*/
Select null /\/\/\/\/\/\/\/\/\/\/\/\
/*
---------------------
NULL
(1
row(s) affected)...
2010-07-29
5,834 reads
Interviewed by Andy Leonard
Last year Brent Ozar interviewed all the candidates for the PASS Board of Directors. I think it went over pretty...
2010-07-29
1,916 reads
Blogs
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
Forums
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers