Viewing the results before and after, during Update
DBAs & Developers using everyday UPDATE statement, and everytime before update they want to see what to update, after this they...
2010-05-06
3,499 reads
Blog Posts
Where Do I Start with PowerShell?
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I...
2010-05-06
5 reads
Where Do I Start with PowerShell?
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend a bunch of time searching for different sites I...
2010-05-06
15 reads
Where Do I Start with PowerShell?
Introduction
This morning I set out to get some information about getting started in PowerShell for a coworker. Rather than spend...
2010-05-06
3,220 reads
American Express PASS Card (Not What You Think)
Had logged in to American Express check my business account and noticed this on on the front page – a PASS...
2010-05-05
580 reads
Getting a Page of Results
The other day I was looking over a couple of articles on paging, looking to see if I could learn...
2010-05-05
409 reads
New SQL Server Standard: Resource Governor by Roy Ernest
The latest issue of the SQL Server Standard is available for download (login required, free registration). Volume 7 Issue 4...
2010-05-05
736 reads
Review: SSD Tweaker
Ran across this while doing some other reading, SSD Tweaker lets you change a few settings that are supposed to...
2010-05-05
574 reads
SQL 2005 TableSpace
In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft. These...
2010-05-05
4,707 reads
SQL Server Integrity Checks – DBCC CHECKDB
I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it....
2010-05-05
2,185 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...