SQL Server Archives - Page 61 of 393 - SQL Authority with Pinal Dave

SQL SERVER – How to See Active SQL Server Connections For Database

August 24, 2014

Another question received via email – “How do I I know which user is connected to my database with how many connection?” Here is the script which will give us answer to the question. SELECT DB_NAME(dbid) AS DBName, COUNT(dbid) AS NumberOfConnections, loginame FROM sys.sysprocesses GROUP BY dbid, loginame ORDER BY DB_NAME(dbid)…

SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation

August 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

After reading my initial two blog posts on New Cardinality Estimation, I received quite a few questions. Once I receive this question, I felt I should have clarified it earlier few things when I started to write about cardinality. Before continuing this blog, if you have not read it before…

SQL SERVER – Backing Up and Recovering the Tail End of a Transaction Log – Notes from the Field #042

August 21, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Notes from the Field

[Notes from Pinal]: The biggest challenge which people face is not taking backup, but the biggest challenge is to restore a backup successfully. I have seen so many different examples where users have failed to restore their database because they made some mistake while they take backup and were not…

SQL SERVER – Cardinality Estimation and Performance – SQL in Sixty Seconds #072

August 20, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video

SQL Server Management Studio

Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced cardinality estimation in SQL Server 2014 and how it improves the performance of the query. The cardinality estimation logic is responsible for quality of query plans and majorly responsible for improving…

SQL SERVER – Simple Demo of New Cardinality Estimation Features of SQL Server 2014

August 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server 2014 has new cardinality estimation logic/algorithm. The cardinality estimation logic is responsible for quality of query plans and majorly responsible for improving performance for any query. This logic was not updated for quite a while, but in the latest version of SQL Server 2104 this logic is re-designed.…

SQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course

August 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video, SQLAuthority News

SQL Training

Click here watch SQL Server 2014 Administration New Features. SQL Server 2014 was released earlier this year and it has been extremely popular in Microsoft world. Here is the announcement for everyone, who have been asking me to build a tutorial around SQL Server 2014. I have authored latest Pluralsight…

SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format

August 17, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

Here is another question I received via email. “Hi Pinal, I have a unique requirement. We measure time spent on any webpage in measure of seconds. I recently have to build a report over it and I did few summations based on group of web pages. Now my manager wants…