Execution Plans, What Do I Look At?
The question came up, what are the top 3-5 things that you look at in a query. I realized then...
2012-01-30
1,829 reads
Blog Posts
New article: Identifying What Runs at Startup on SQL Server
Another article has published over at MSSQLTips.com. This one covers how to identify what stored procedures are set to run when...
2012-01-30
938 reads
RYO Maintenance Plan – Database Backups, Part 2
Last time I dealt with the creation of subdirectories, in one or more root locations, to house my database backups....
2012-01-30
1,847 reads
Slammer, Alive…Barely
Slammer
By now you must have heard of the SQL Slammer worm. It was quite an infectious little nuisance. The harm...
2012-01-30 (first published: 2012-01-24)
2,428 reads
SQL server – ISNUMERIC and checking for valid numeric tyopes
During a large ETL process from a staging table , UPDATE was creating an error on a CONVERT.
Msg 245, Sev 16,...
2012-01-30
1,072 reads
System Base Tables
On January 19th, I published a post about the Dedicated Administrator Connection. I spoke very briefly of the system base tables in that article. Today, I want to dive...
2012-01-30
8 reads
System Base Tables
On January 19th, I published a post about the Dedicated Administrator Connection. I spoke very briefly of the system base...
2012-01-30
1,403 reads
The affordable self-service BI revolution has started.
I am officially announcing that I have now become an independent consultant and business owner. Becoming independent has always been...
2012-01-30
1,877 reads
The Idera ACE Program, So Far
The Idera ACE program is something I’ve been involved with for over a year now. I’ll share a bit of...
2012-01-30
1,670 reads
When DBCC INPUTBUFFER disappoints
Today we have an alert from one of the client server about blocking, I have immediately start looking at it...
2012-01-30
1,727 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kantor BCA KCU KALIMALANG Tlp/Wa:0817839777
Tlp/Cs: 0817839777 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit,...
Alamat Kantor BCA KCU SITUBONDO Telp:0817839777
WhatsApp: 0817839777 Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur 68311
Alamat Kantor BCA KCU TUBAN Telp:0817839777
WhatsApp: 0817839777 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers