Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it...
2008-03-28
1,526 reads
Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it...
2008-03-28
1,526 reads
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is...
2008-03-28
1,441 reads
How do you know what procedures are cached in SQL Server? Simple, just ask, and SQL Server will tell you.You...
2008-03-28
1,467 reads
Here's a good article on setting up Deadlock Notifications in SQL Server 2005 written by Patrick LeBlanc.
2007-10-16
1,479 reads
Q I need an easy way to see if a delete transaction has fired a trigger. Do you have any...
2007-08-01
615 reads
Breaking Up is Easy to DoHardIt's nice to be able to package a process into a single, tidy, elegant query,...
2007-07-03
598 reads
Some of you younger DBA’s out there may not know who Neil Sedaka is or remember his poignant words "Breaking...
2007-07-03
607 reads
The active SQL Server error log is one of the first places people look when there is a problem. For...
2007-06-29
1,593 reads
No, I'm not going to keep making corny references to war and being a soldier. But in many ways, we...
2007-06-29
1,335 reads
Checks the default file locations for your data and log files. If not set, it sets them to the specified values. This is written for a SQL 2005 default instance. Registry paths may be different for SQL 2000 or named instances.The script can be easily modified to update it if the current value is set […]
2007-01-01 (first published: 2006-12-21)
880 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Hi, it isnt clear from the web if something like this should work as...
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers