|
|
-
|
|
In this post, I present an alternate to Table Valued Parameters for SQL Server 2000. Support for Microsoft SQL Server 2000 ends this year and yet, one can find systems (production or otherwise) that continue to run on and support SQL Server 2000. The solution presented in this post might be useful to such products....
|
|
-
|
|
Although one of the most robust change and tamper detection mechanisms available in Microsoft SQL Server, HASHBYTES suffers from a limitation that it cannot handle more than 8000 bytes of input, which translates to 4000 NVARCHAR characters....
|
|
-
|
|
Hi friends We have started analyzing PowerPivot a way back in Sept 2011. I have only one post written on it which as below, In which I have explained all basic stuff related to it : MSBI # 39 – PowerPivot #1 – Introduction to Microsoft SQL Server Pow...
|
|
-
|
|
MySQL provides top 6 commands to maintain database table more efficiently. These six commands enable users to analyze, backup, optimize, check, repair and restore MySQL database tables...
|
|
-
|
|
When working on development projects, one may need to restart servers and/or workstations often. When working from remote locations or on virtual machines hosted on the network, this often becomes a challenge. Today, I will show how to shutdown or restart a local or remote machine via the command prompt....
|
|
-
|
|
Do you have the experience of getting errors for sort for grouped data in Excel? One of problems that most complained during the retail data analytics is further computations on grouped data. While the retail data stored in Excel, it could be time-consuming and fussy with computations on grouped data, especially when there are a lot of groups. Check this articles for my solution....
|
|
-
|
|
Here I’ll share you how to put logging in your C++ application using QT 5.0 framework. It is very easy to implement, first you need to setup message handler once in application then it will return pointer to previous message hander defined. The message ...
|
|
-
|
|
You can do conditional aggregation like SUM(CASE WHEN .. THEN 1 ELSE 0 END),....etc to find a count for a particular match. This type of conditions are useful when you want to write a CROSS-TAB/PIVOT Query. You can also make use of COUNT(CASE WHEN .. TH...
|
|
-
|
|
A database rename operation in Microsoft SQL Server may fail due to multiple reasons - the most common of all being an open connection to the database. Often this is because of the SSMS itself. In this post, I present a simple script that can be used to rename a SQL Server database if open connections are preventing the operation....
|
|
-
|
|
This week, I resolved one issue which I received continuously which is noting but exactly displayed in post title. The issue occurred when I ran ssis package with batch file or scheduled job and same error message raised. Source: Start Exe...
|
|