|
|
-
|
|
Dependency Injection and Inversion of Control (IoC) are one of the key players in todays web architectures. DI improves code reusability and guarantees loosely coupled systems. Having a DI onboard will help in both code maintenance perspective and applicat...
|
|
-
|
|
Parallel Data Warehouse Tip (PDW): Surrogate Key Generation
IDENTITY is not supported on PDW so you’ll want to do a table based surrogate key assignment or use INSERT w ROW_NUMBER() with the OVER clause. I prefer using ROW_NUMBER().
USE [PDWDB]
CREATE TA...
|
|
-
|
|
sys.dm_exec_procedure_stats DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/cc280701.aspx
Returns aggregate performance statistics for cached stored procedures. The view contains one row per stored ...
|
|
-
|
|
Introduction Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011. The idea was to show a Calendar for the selected month and each cell of the calendar should display the scheduled events of that day...
|
|
-
|
|
Normal
0
false
false
false
EN-US
X-NONE
X-NONE
...
|
|
-
|
|
Before we dive in to the post, I’d like to give a big thank you to Bob Pusateri (Blog|Twitter) for hosting this months T-SQL Tuesday “Presenting and Loving it!”. T-SQL Tuesday was the brainchild of Adam Machanic (Blog|Twitter) you can find out more about t...
|
|
-
|
|
Filtered index is a new feature introduced in SQL Server 2008. All the indexes that we have discussed till now were always on the entire table. In other words, Index and table will have same number of records.With filtered index, it is possible to...
|
|
-
|
|
sys.dm_exec_cached_plans DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/ms187404.aspx
Returns a row for each query plan that is cached by SQL Server for faster query execution. You can use this dyn...
|
|
-
|
|
The bank holiday and work have put me a few days behind schedule, but here is the list out all of the UK events for all you busy people who forget to go over to http://www.SQLServerfaq.com to check what SQL Server events are happening in the UK this mont...
|
|
-
|
|
Ever wanted to know all there is to know about SQL Server, and afraid to ask? Have questions about how it will scale, how it applies to your own infrastructure project? Want to find out the future direction of the SQL Server product? Who better to ans...
|
|