ROWS PRECEDING and FOLLOWING in TSQL 2012
First for this example, and a few to follow we need to create the database that we are going to play around in. Next a review of the OVER clause as it is support prior to SQL Server 2012. Which …
Month: March 2012
New DMV in SQL Server 2012 sys.dm_server_services
One of the new Dynamic Management Views introduced in SQL Server 2012 is the dm_server_services which returns info on the services running that are associated with SQL Server. select * from sys.dm_server_services; Give it a try. Looking this over, the first thing that …
New DMV in SQL Server 2012 sys.dm_server_services Read more »
No more Business Intelligence Development Studio in SQL 2012
There is no more Business Intelligence Development Studio (BIDS) in SQL Server 2012, instead it has been replaced with the SQL Server Data Tools that uses the core of Visual Studio 2010, with the Report Builder and Report Designer built …
No more Business Intelligence Development Studio in SQL 2012 Read more »
SQL Server 2012 – Setup Problems – Value Cannot Be Null
After several attempts to install SQL Server 2012 on Windows 7, I was getting the following error. “SQL Server Setup has encountered the following error: Value cannot be null. Parameter name: doc.” After 4 retries with different options I finally …
SQL Server 2012 – Setup Problems – Value Cannot Be Null Read more »
2 New Reports Added to the SQL Server Health Reports
I added 2 new reports Top Cache Queries and Top CPU Queries into the Server Health Reports. Here is a screen shot of the latest report, the Top CPU Queries report: Enjoy….
A great day at SQL Saturday in Vancouver BC
I spent the day today at SQL Saturday in Vancouver BC. I met some fabulous SQL Server professionals, and presented 2 sessions. The first Session was on Unleashing Common Table Expressions in SQL Server. This was the second time …
SQL Server Health Reports – Updated
In preparation for my presentation at SQL Saturday in Vancouver BC tomorrow, I have updated the SQL Server Health Reports. As I was preparing for my presentation I discovered a few areas that I wanted to improve on the layout, …
4 Sessions Submitted to Seattle Code Camp
It has been a busy week getting ready for SQL Saturday Vancouver, planning sessions to present at future training’s and determining new material to present. Today I submitted 4 sessions to Seattle Code Camp for their June session. Using SSRS …
SQL Server Health Reports Updated
The SQL Server Health Reports have been updated. As part of preparing for my SQL Saturday 114 presentation next weekend in Vancouver BC, I have updated the SQL Server Health Reports one more time. The latest update included lots of minor …
How big is your procedure cache?
Part of SQL Server running queries is that once a query is analyzed, parsed and compiled, that compiled plan is kept in memory so that it can be quickly re-used in the future. If you are using proper parameterized queries, …