|
|
-
|
|
One of the most popular of the blogging tools currently being used is the Windows Live Writer. In order to configure the Windows Live Writer to work with your blog on the Blogs Module of BeyondRelational.com, you only need to follow the following very s...
|
|
-
|
|
One of my friends asked me if it is possible to load multiple resultsets returned from a stored procedure into a temporary table for some analysis purpose. The answer is "It depends". If all the resultsets return same number of columns then it is possib...
|
|
-
|
|
Money is one of the datatypes in SQL Server and it can be used to store monetary values. It will not only accept integer and decimal values but formatted values too. For example you can express values that include comma and currency symbol
Consider the ...
|
|
-
|
|
Recently while working with one query to get schedule jobs status, i used xp_sqlagent_enum_jobs object which gives details of state values of all jobs in msdb database and this is undocumented object. But received an error while running following query ...
|
|
-
7
Liked
| 6
Learned
| 4
Comments
|
|
Earlier on Beyondrelational I read a tip, for the same topic.
combination of keys Shift + Print screen, allows us to take screen shot of Remote Desktop.
But recently I faced problem using these keys. It allowed taking print screen only once. Every other...
|
|
-
|
|
You may worked with xml and you may aware of title mentioned in this post. Today when I was working to collect information from one table which having xml column, I was trying to open xml data result set from query analyzer with new query window. For so...
|
|
-
|
|
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...
|
|
-
|
|
Because of data growth and performance issue we need to move tables or indexes to other filegroups. The purpose of moving tables or indexes to improve the database performance as it reduce I/O from single drive or single filegroup. We can create another...
|
|
-
6
Liked
| 7
Learned
| 1
Comments
|
|
Recently I am surfing on net I found useful post for LINQ there is a Zip Operator is introduce in LINQ thread two list together
eg.
[code]
string[] codes = { "CAD","HRK","ILS", "JOD", "LTL"};
string[] states =
{
" Canadian Dollar",
"Cr......
|
|
-
|
|
How to make a package dynamic or parameterize the package. ...
|
|