|
|
-
|
|
How do you know when your index was last rebuilt or reogranized? How many records changed during this rebuild/reorganization operation? Read this post for answers to all these questions....
|
|
-
|
|
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...
|
|
-
|
|
You might be hearing people talking much about cloud computing these days . You might be wondering what is Cloud & Cloud Computing. In this blog post I just wanted to give overview of Cloud & Cloud Computing and continue to write series of blog posts related to Cloud Space. In technical te......
|
|
-
|
|
Almost every product comes with a set of predefined system default data. There are very few product teams who use row constructors (introduced in SQL Server 2008) to populate their default data. What these teams fail to realize is that many a times, the conventional approach may have a negative impact on the time it takes to insert the data and also reduces the overall efficiency of the entire data load operation....
|
|
-
|
|
SQL Server 2012 (“Denali”) introduces many new features directed towards improving server efficiency and availability and developer/administrator productivity. SQL Server 2012 no longer supports compatibility level 80 (SQL Server 2000) and this introduces the user to error message: 15048, which arises when an incorrect database compatibility level is used....
|
|
-
|
|
One of my collegues told me that while we cannot use a temporary table created inside dynamic sql out of it, in a similar way it is not possible inside dynamic sql to access a temporary table created out of dynamic sql. How many of you think this is tru...
|
|
-
|
|
We have seen example of Changing Rows to Columns Using PIVOT. Hope you liked that post and you enjoyed a lot also. As we know that we need to hard-code the values for pivoting which we have did for color values. for the values updates in table or whenev...
|
|
-
|
|
As per requirement in custom logic we need to require CTE (Common Table Expression) something like for the hierarchy, to find duplicate and remove data or for some other stuff. Recently i have used CTE within CTE for one logic and maxrecursion option as...
|
|
-
|
|
Whenever we talk about inclusive date comparison & filtering in T-SQL, the only two options that come to mind are the BETWEEN clause and the greater than (>) and less than (<) operators paired with the equal to operator. Today, let us attempt to find out if there is a difference between the two.......
|
|
-
|
|
If you put jQuery in your CV, then beware, you should be able to answer following questions. Better you read on, and test yourself how much you can score. 1. What is jQuery & its significance? Why it is so popular? 2. What is jQuery UI? 3. What are various jQuery Features? 4. What do Dollar......
|
|