|
|
-
|
|
When we use index query hint, we can give the index number or index name. I use an index hint for testing performance purpose only and almost never use it in actual code. I tend to use index numbers in test code. But, till some time ago I used to wonder...
|
|
-
|
|
Have you ever need to transpose a whole table? Mostly you need not, neither did I. We might need some kind of cross-tab resultsets mainly while doing Reporting and reporting tools are well versed for handling this requirements and that should be used. B...
|
|
-
|
|
Warning:- Settings mentioned below are listed by keeping developer workstation in mind. Even if some setting might applicable for live production server, please refrain using the same script or recommendation from this post against SQL production/UAT/QA...
|
|
-
|
|
Yesterday morning when I was checking my mails, I received mail from support@microsoftcommunitycontributor.com with subject “Your online community contributions have been recognized by Microsoft”
I was pretty surprised to see this mail. Microsoft awarded me Microsoft Community Contribu......
|
|
-
|
|
KeepTogether Tablix Property Setting should be used with care. This can cause whole report to load in single page and your report builder or web application (Reportviewer Control) can become very very slow in rendering.
This property can be set as shown in below image:
<img src="/resized-image.ash......
|
|
-
|
|
Before we directly jump to the topic, I would like to give a basic introduction of SELECT..INTO statement.
As, we know that, select into statement can be used to create new table with same table structure and to insert a base table rows in new table. We need to consider following things before usin......
|
|
-
|
|
In one of our applications delta table is used to track changes. This delta table for one entity which also holds information for anything is added/deleted and updated for this entity and so this delta table gets updated by many related tables. For exam...
|
|
-
|
|
Note:- Please refer to post mentioned here to see why there are less number of log records. Actully this is not minimal logging but its less number of log records/
As per BOL ( here and here), minimal logging is only possible in SIMPLE and BULK-LOGGED recovery mode using bulk operations and FULL ......
|
|
-
|
|
As we know, we can write case expression in SQL in two ways.
As per BOL, defination of these two diffrent formats of CASE expression: - The simple CASE expression compares an expression to a set of simple expressions to determine the result.- The searched CASE expression evaluates a set of Boolea......
|
|