|
|
-
|
|
Checkout the sixth part of my XML support and SQL Server article series here.
In this part, you will learn about XML indexes (primary and secondary), and how they can effectively improve xQuery performance. You will also learn how you can manage the XML in...
|
|
-
|
|
Like other mainstream commercial database systems, Microsoft SQL Server allows you to create multiple indexes on the same column of a table. This increases the likelihood of having duplicate indexes in the database because SQL Server does not prevent you ...
|
|
-
|
|
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check some processes details and opened Activity Monitor after a long long time.
Straight away I was struck with this error.
By using the ‘...
|
|
-
|
|
Things are really ramping up in May and June this year, it’s a great time to be an IT Professional with so much free SQL Server training available!
This month there are 9 events planned including the Europe’ premier SQL Server SQLBits. If you...
|
|
-
|
|
Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing SQL Server Performance” with Patrick O’Keeffe who is Director of Software Development at Dell Software Group. I must say, it was a really interesting...
|
|
-
|
|
2003, 2008, 2008 R2
SQL Server 2000, 2005, 2008, 2008 R2, 2012
*/
sp_configure 'show advanced options',1
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'xp_cmdshell',1
RECONFIGURE WITH OVERRIDE
GO
DECLARE @TimeZone NVARCHAR(100)
,@ProductVersion SYSNA...
|
|
-
|
|
Thomas La Rock (Blog | Twitter) recently wrote a blog post about misplacing a device he has called a FitBit One which is a pretty cool piece of kit, it’s entitled “How to find a missing FitBit”. For those of you who don’t know what they are, think of it ...
|
|
-
|
|
I was working with ADFS 2.0 (“Active Directory Federation Services”) for a while when this simple question crossed my mind: How can I figure out if the connection between ADFS and AD “works”? Here is a simple test…
What is ADFS?
If you need some “posit...
|
|
-
|
|
sys.dm_clr_tasks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/ms177528.aspx
Returns a row for all common language runtime (CLR) tasks that are currently running. A Transact-SQL batch that contains a re...
|
|
-
|
|
Most of us already knew the traditional routing concepts in Web API which we configure in WebApiConfig file. This approach solves most of the basic routing problems, but it limits the granular control and flexibility over custom routes. Attribute based rou...
|
|