From time to time I field questions regarding Database Mail usage within SQL. Questions come from all over discussing how to identify what the job is doing or what the job has done. Sure, you can send some test mails through the nice GUI part, but that is not what this post is about. I …
Tag: SQL Server
Why is Count(*) Taking So Long
Phone rings……..I answer…….a DBA from a third party vendor has supplied someone with two scripts. The first script is a simple insert with a where clause: insert into [databasename].[dbo].[tablename] ( column1,column2, column3, column4 ) select column1, column2, column3, column4 from [databasename].[dbo].[tablename] where column1<[integeramount] and column1>[integeramount] First question I ask; how much data is loading into …
T-SQL Tuesday #040: File and Filegroup Wisdom
It’s that time again for the T-SQL Tuesday party! This party was created by none other than Adam Machanic (Twitter). If you are interested in hosting a party at some point this year give him a shout; you need to have participated in two T-SQL Tuesdays along the way and also maintain your own blog …
Continue reading T-SQL Tuesday #040: File and Filegroup Wisdom
Select * Syndrome
Something that I have seen lately over and over again and even ran into this morning is a practice that I would say is a pretty bad habit in SQL….the dreaded Select * syndrome This method is heavily used for adhoc querying and I've seen it used in some troubleshooting scenarios but in my case …
Dashboard Time
I was fortunate enough to attend the PASS 2011 Summit in Seattle. If you do not know what I am speaking of when I say PASS I encourage you to check it out. PASS stands for Professional Association for SQL Server. The event that is put on yearly speaks for itself and I can dedicate …
Who Do I Follow? Where Do I Go?
There are many helpful sites within the SQL Community and several more blog sites that I follow. My favorites are noted on this site; however one that keeps drawing me back time and time again is by Brent Ozar's group. For those of you who have not had the opportunity to check the site out …
The Microsoft SQL Server MVP
What is an MVP? For myself growing up in the realm of sports through high school and college an MVP is a most valuable player. In general an MVP is recognized in his area or field, an honor bestowed on him or her that distinguishes them as being recognized by their peers. What is a …
"You are the CEO of your destiny" 