My Love with SQL Server
9.9K views | +2 today
Follow
My Love with SQL Server
Anything about SQL Server
Curated by Shyam Viking
Your new post is loading...
Your new post is loading...
Scooped by Shyam Viking
Scoop.it!

It’s Hard To Destroy Data

It’s Hard To Destroy Data | My Love with SQL Server | Scoop.it
It is surprisingly difficult to delete data permanently. SQL Server has sophisticated features that prevent all kinds of data loss, but the opposite is not
Shyam Viking's insight:

It’s Hard To Destroy Data

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

SQLskills holiday gift to you: all 2013 Insider videos

SQLskills holiday gift to you: all 2013 Insider videos | My Love with SQL Server | Scoop.it
As we all wind down for the 2014 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’ for all your support during 2014, and what better gift than more free content?
more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

New Trace Flag to Fix Table Variable Performance

New Trace Flag to Fix Table Variable Performance | My Love with SQL Server | Scoop.it
Following the recent release of SQL Server 2012 Service Pack 2, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag aimed at improving ca...
Shyam Viking's insight:

New Trace Flag to Fix Table Variable Performance

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Lost Identity

Lost Identity | My Love with SQL Server | Scoop.it
Way long ago, when Sybase first added the IDENTITY property, it took people quite a while to get the hang of using it. Along with being able to automatically generate sequential numbers for each row, we had to tune a configuration option with the geekiest
Shyam Viking's insight:

Lost Identity

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Adventures with SQL Server & perfmon Part 1: Resource Governor & Query Memory

Shyam Viking's insight:

Resource Governor & Query Memory

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Optimizing Transaction Log Throughput

Optimizing Transaction Log Throughput | My Love with SQL Server | Scoop.it
As a DBA, it is vital to manage transaction log growth explicitly, rather than let SQL Server auto-growth events "manage" it for you. If you undersize the log, and then let SQL Server auto-grow it in small increments, you'll end up with a very fragmented log. Examples in the article, extracted from SQL Server Transaction Log Management by Tony Davis and Gail Shaw, demonstrate how this can have a significant impact on the performance of any SQL Server operations that need to read the log.
Shyam Viking's insight:
Optimizing Transaction Log Throughput
more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

How Automatic Updates to Statistics Can Affect Query Performance

How Automatic Updates to Statistics Can Affect Query Performance | My Love with SQL Server | Scoop.it
Erin Stellato (@erinstellato) of SQLskills performs some tests to evaluate the effect end users might expect from automatic updates to statistics.
Shyam Viking's insight:

How Automatic Updates to Statistics Can Affect Query Performance

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc. | My Love with SQL Server | Scoop.it
Shyam Viking's insight:

AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

A row with no fixed length columns

Today I will return to my roots and post about the bits and bytes of internal storage. I received a request a while back to help with deciphering the DBCC PAGE output for a row with no fixed length columns.
Shyam Viking's insight:

A row with no fixed length columns

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Cardinality Estimation for Multiple Predicates

Cardinality Estimation for Multiple Predicates | My Love with SQL Server | Scoop.it
Shyam Viking's insight:

Cardinality Estimation for Multiple Predicates

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

SQL Server Storage Engine: Allocation Maps

SQL Server Storage Engine: Allocation Maps | My Love with SQL Server | Scoop.it
SQL Server logically groups eight pages into 64KB units called extents. There are two types of extents available: Mixed extents store data that belongs to different objects. Uniform extents store t...
Shyam Viking's insight:

SQL Server Storage Engine: Allocation Maps

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Why is log_reuse_wait_desc saying LOG_BACKUP after doing a log backup?

Shyam Viking's insight:

Why is log_reuse_wait_desc saying LOG_BACKUP after doing a log backup?

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

How can you tell if an index is being used?

Shyam Viking's insight:

How can you tell if an index is being used?

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

How come sys.dm_exec_requests.cpu_time never moves?

Shyam Viking's insight:

How come sys.dm_exec_requests.cpu_time never moves?

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Top Support Solutions for Microsoft SQL Server 2012

Microsoft Support solutions important to IT professionals. Get links and RSS/Atom feeds to the best Microsoft KB articles, blogs, TechNet, and MSDN articles related to issues that affect IT professionals. Topics related to Microsoft Configuration Manager, Dynamics, Exchange Server, Forefront, Lync, SQL, Sharepoint, Small Business Server, System Center, UAG, Windows Server, and more.
Shyam Viking's insight:

Top Support Solutions for Microsoft SQL Server 2012

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

White Paper Gallery for SQL Server

White Paper Gallery for SQL Server | My Love with SQL Server | Scoop.it
Technical articles, content and resources for IT Professionals working in Microsoft technologies
Shyam Viking's insight:

White Paper Gallery for SQL Server

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Dude, who owns that #temp table?

Dude, who owns that #temp table? | My Love with SQL Server | Scoop.it
SQL Sentry's Aaron Bertrand (@AaronBertrand) shows how you can use Extended Events to track temp table creation and identify which session created which #temp table.
Shyam Viking's insight:

Who owns that #temp table?

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Causes of IO_COMPLETION and WRITE_COMPLETION SQL Server wait types

Causes of IO_COMPLETION and WRITE_COMPLETION SQL Server wait types | My Love with SQL Server | Scoop.it
In many of the sets of wait statistics I’ve been analyzing, the IO_COMPLETION and WRITE_COMPLETION waits show up (but never as the most prevalent wait type). The official definition of these wait types are: IO_COMPLETION: Occurs while waiting for I/O operations to complete. This wait type generally represents non-data page I/Os. Data page I/O completion waits appear …
Shyam Viking's insight:

Causes of IO_COMPLETION and WRITE_COMPLETION SQL Server wait types

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

How to move databases configured for SQL Server AlwaysOn

Shyam Viking's insight:

How to move databases configured for SQL Server AlwaysOn

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

Shyam Viking's insight:

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Default Configuration of SQL Server (and query hints)

Throughout the years, I have become convinced that the default settings used in SQL Server are often wrong for systems that need scale or are properly managed. There is a series of settings I find ...
Shyam Viking's insight:

Default Configuration of SQL Server (and query hints)

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Kalen Delaney : Geek City: sp_cacheobjects for SQL Server 2012

Kalen Delaney : Geek City: sp_cacheobjects for SQL Server 2012 | My Love with SQL Server | Scoop.it
In a post about 4 1/2 years ago , I gave you my version of a replacement for the old pre-2005 pseudotable syscacheobjects . I called it sp_cacheobjects and created it as a view in the master database.
Shyam Viking's insight:

Another version of syscacheobjects by Kalen.

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Kalen Delaney : Geek City: Did You Know … that not everything you know is actually true!

Kalen Delaney : Geek City: Did You Know … that not everything you know is actually true! | My Love with SQL Server | Scoop.it

Software changes, new versions not only add new features, they also change internal behavior of old features, and not all the changes are documented! > CAN rollback a TRUNCATE TABLE

Shyam Viking's insight:

CAN rollback a TRUNCATE TABLE

more...
No comment yet.
Scooped by Shyam Viking
Scoop.it!

Are I/O latencies killing your performance?

Are I/O latencies killing your performance? | My Love with SQL Server | Scoop.it
Shyam Viking's insight:

Are I/O latencies killing your performance?

more...
No comment yet.