Monday, March 30, 2015

My Report takes long time to load, where should I check initially?

›
If you are the DBA or DBE, and reports have been deployed in production environment, question like above is very common? Usually quotes ar...
Sunday, March 29, 2015

SQL Server Brain Basher of the Week #005

›
Can I use sp_recompile with tables? What would be your answer? Yes or no ? Answer should be Yes  but it does not mean that we can ...
Thursday, March 26, 2015

My Application needs a new sequence number to the table without inserting the record

›
This is something I discussed with one of my colleagues, it was all about obtaining the next sequence number from Identity type column wit...
Tuesday, March 24, 2015

I declared a nvarchar(max) variable but it holds only 4000 characters

›
Although getting questions from SQL Server enthusiasts makes me busy, this brushes up my knowledge significantly. This is one of the quest...
Sunday, March 22, 2015

SQL Server Brain Basher of the Week #004

›
Here is another tricky question? It is on Indexing. Can we create an index without mentioning what column(s) to be used? Obviously...
Saturday, March 21, 2015

How to get system/error messages with severity level lower than 19 logged to Application Log

›
Have you noticed that SQL Server does not send all messages to Application Log? The default setting does not send all messages, generally ...
Thursday, March 19, 2015

I changed the Recovery Model before BULK operation, is it a good practice?

›
I have already written a post on bulk operations , indicating the benefits we get by changing the recovery model before performing bulk o...
Tuesday, March 17, 2015

How to fill the plan cache efficiently - Optimize for ad hoc workloads option

›
It is good to keep all plans used for compiled queries in the memory, as it helps to optimize the query processing, allowing engine to reu...
Monday, March 16, 2015

Does SQL Server use same cached plan for same statement with subsequent execution?

›
When you send a request to SQL Server, it takes your statement via four main steps. Generating a plan for it is part of these four steps. ...
Sunday, March 15, 2015

SQL Server Brain Basher of the Week #003

›
This week Brain Basher is based on data/time. See below code and try to guess the output of it. DECLARE @datetime datetime SET @dateti...
Saturday, March 14, 2015

Can we get SQL Server service and Agent service automatically restarted at unexpected stopped?

›
We know that Windows Services  have an option to get them started automatically configuring the Start Mode . But this is only with Windows...
Friday, March 13, 2015

How to create a simple database-level audit using SQL Server Audit

›
How do you implement "Auditing" with your SQL Server database? Do you know that SQL Server Audit is the best and simplest way of...
Thursday, March 12, 2015

Number of records in Non-Clustered Index Leaf Level is same as records in the table?

›
This is one of the questions I got in last week. To make it more clearer, the question is, when we have 1,000,000 records in a clustered-st...
Sunday, March 8, 2015

SQL Server Brain Basher of the Week #002

›
Here is the Brain Basher of this week. As you know, if you have multiple objects to be deleted, for an example, 3 tables, we write three s...
Saturday, March 7, 2015

How to change the data type of a column of a large table

›
Here is another common question appeared in forums, how to change the data type of column, specifically a large table. If you search for i...
Thursday, March 5, 2015

How to load/insert large amount of data efficiently

›
Importing data from other sources is a very common operation with most of database solutions as not all data cannot be entered row-by-row....
Wednesday, March 4, 2015

SSRS Multi Value Parameters with MDX and checking whether all values are selected

›
It is a very common question in many forums: How can we check whether all values in the parameter are selected and how to add selected val...
Monday, March 2, 2015

Free Microsoft SQL Server preparation courses at Virtual Academy for exams 464 and 465

›
Microsoft Virtual Academy has added two new preparation courses for SQL Server exams. Theses two courses cover  Developing Microsoft SQL S...
Sunday, March 1, 2015

SQL Server Brain Basher of the Week #001

›
I have been doing a series of session called SQL Server Brain Basher in SQL Server Sri Lanka User Group  ( https://www.facebook.com/group...