Resource Governor clamps down on Greedy Reports
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,306 reads
Blog Posts
Sometimes temp tables can be your best friend
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was...
2011-10-10
894 reads
SQL Saturday 98 Follow-Up
I’ve been meaning to follow-up with links to the presentations that I delivered at SQL Saturday 98. It’s a few...
2011-10-10
582 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2011-10-10
906 reads
sys.dm_os_loaded_modules
sys.dm_os_loaded_modules is a SQL Server OS Dynamic Management View (DMV).
When executing the t-sql statement below – a recordset is returned . I’ve...
2011-10-10
2,426 reads
The PASS Summit is HERE!
Watching the twitter sphere it is apparent that many of the SQL Nation are in route to Seattle WA today....
2011-10-10
470 reads
PASS 2011 Countdown – Starting Now
Seriously, the clock is ticking and you should be in your car or a plane for PASS Summit by now. ...
2011-10-09
739 reads
An Informal Compendium of SSAS Errors, Part 4: SSAS Object Design
This is the third in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-10-08
2,212 reads
DBCC checktable
Instead of using DBCC CHECKDB , which checks on consistency and allocation across the whole database, an alternative is DBCC CHECKTABLE...
2011-10-08
2,713 reads
#SQLGive Update - New Dropoff Locations
Since announcing #SQLGive earlier this week I'm happy to report that two additional vendors have agreed to host dropoff boxes...
2011-10-07
855 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers