|
|
-
|
|
In this post, I use the MODIFY FILE clause of the ALTER DATABASE statement to rename the logical file of a database. This is most often useful during product/organization re-branding. This approach is fast because it does not require a transfer of data to a new database....
|
|
-
|
|
Before a couple of days we planned to manual failover of production servers and all live databases for that instance to mirror instance and did a failover too. It was a best experience for failover without fail anything like replication, scheduled jobs,...
|
|
-
|
|
Recently I was using resharper to refactor some of my code and found that it was suggesting to use any() extension method instead of count() method in List. I was really keen about performance and found that resharper was right. There is huge performanc...
|
|
-
|
|
SQL Server Error log is the best option for a DBA to identify any current or potential issues with SQL Server databases. These error log files contain a broad range of error messages that provide valuable information with respect to automatic recovery, kernel problems, and other server-level problems....
|
|
-
|
|
Problem: Recently one of my friend was needed only first three rows of data table and so he asked me and I have multiple solutions for that. So thought it would be great idea to share with you guys. Possible Solutions to problem: There are two way...
|
|
-
|
|
This post is a continuation of the Row Selection Using Slicers in PowerPivot – Part 1 (so it might be a good idea to read that post before this). In our last post, we discussed the basic solution pattern for row selection using slicers in PowerPivot. In...
|
|
-
|
|
Functions such as NonEmpty(), Filter() and Exists() must use a numeric expression Many of the MDX functions, such as NonEmpty(), Filter() and Exists(), seem to be easy enough to use, but they present quite a challenge for people with T-SQL background....
|
|
-
|
|
HI All,
Thought of starting sql server-2012 Tutorial. Feedback are most welcome....
|
|
-
|
|
While DMVs are some of the most powerful features of Microsoft SQL Server, they are still under-utilized due to the lack of awareness around them. Nevertheless, each release of Microsoft SQL Server comes with a new set of DMVs being introduced & existing DMVs being modified to expose more valuable information/details. Once a week for the next couple of weeks, my posts will be centered around the DMVs & Catalog Views modified in SQL Server 2012....
|
|
-
|
|
In 1993, E.F. Codd, the acknowledged founder of relational databases, introduced the term Online Analytical Processing (OLAP). OLAP is intended for the non-data processing professionals like the business expert, and is expected to be intuitive, rapid, and flexible. Here i mainly talk about traditonal OLAP's drawbacks....
|
|