sqlfingers.com: Contact Us

SQL Server Consulting

Home
SQL Server Consulting
SQL Server Health Check
Support Types & Pricing
About
Contact

Contact Us

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

Home

Subscribe to: Posts (Atom)

Search

Topics

SQL Server Health Check
Helpful tSQL
Performance Tuning
SQL Server Security
Database Maintenance
Disaster Recovery

Blog Archive

▼ 2010 (8)
- ▼ December (8)

► 2011 (54)
- ► January (21)
- ► February (9)
- ► March (2)
- ► April (8)
- ► May (12)
- ► June (1)
- ► July (1)

► 2013 (10)
- ► December (10)

► 2014 (40)
- ► January (11)
- ► February (5)
- ► March (1)
- ► May (3)
- ► July (7)
- ► August (3)
- ► September (5)
- ► October (5)

► 2015 (31)
- ► January (4)
- ► February (7)
- ► March (1)
- ► May (1)
- ► June (6)
- ► July (2)
- ► August (3)
- ► October (1)
- ► November (5)
- ► December (1)

► 2016 (21)
- ► January (2)
- ► February (2)
- ► March (4)
- ► April (1)
- ► May (2)
- ► June (6)
- ► July (1)
- ► September (1)
- ► October (2)

► 2017 (5)
- ► January (2)
- ► June (1)
- ► July (1)
- ► August (1)

Popular Posts

Find the unused database tables in SQL Server

I have a customer right now that needs a LOT of cleanup... BIG fragmentation! The tables have not been properly maintained, and the fragme...
DATEPART returns three character month names, date and year.

Just a quick way to CASE the output of the current date, to include the Month Name, as opposed to the numeric digit. Today is 1/9/2011, th...
Forced Parameterization

Forced Parameterization is a fabulous tool for those DBAs fighting all of the ad-hoc coming from the middle tier. Those developers continua...
Using a SQL Server Logon Trigger

One of my customers has an instance where many people log in as sa. We're planning to change the password and rename the sa login, but...
sys.dm_os_memory_clerks

The sys.dm_os_memory_clerks is a very useful DMV for monitoring SQL Server memory performance. You could use sys.dm_os_memory_clerks to ide...
SQL Server Database Mirroring... Error Msg 1412

I had the craziest problem happen recently. Not that it shouldn't have happened, but the error return that I received from SQL Server ...
Start SQL Server Agent job remotely

Sometimes it is necessary to perform administrative tasks on other SQL Servers, remotely. As your inventory grows, using Remote Desktop to ...
Concatenate values with FOR XML PATH

In this example I will show you how to use the FOR XML PATH clause to perform row concatenation, in v2005 and v2008. Let's first creat...
How to uninstall SQL Server Reporting Services (SSRS)

Do you know how to remove SSRS, without uninstalling other components of SQL Server? Easy sneasy, check it out: Go to your Control Panel A...
Add a DEFAULT Constraint

On many occasions over the years, I've enabled a DATETIME attribute on a table, but allowed SQL to populate it for me, with a GETDATE()...

Theme images by mammuth. Powered by Blogger.