Sign in
|
Join
Home
Blogs
Ask
Just Learned
Interview Questions
Puzzles
Tutorials
Quiz
Modules
Getting Started with Adobe After Effects - Part 6:
Motion Blur
Liked
Syndicated Blogs
Upload Image
Close it
Select File
My experiences and references in SQL server
Like
Invite Friends
Browse by Tags ·
View All
SQL Server
14
#SQLServer
14
SQL Scripts
13
#TSQL
6
TSQL
6
SQL Serevr - Issues and Resolutions
3
SQL Server - Best Practises
3
SQL server - Misconceptions
3
SQL server - Statistics
2
SQL Server - Wait stats and Queues
2
Archive ·
View All
October 2011
8
March 2011
7
April 2011
4
May 2011
3
November 2011
3
December 2010
3
December 2011
2
June 2008
2
February 2011
2
February 2012
1
SQLZealot's Blog
Home
·
Most Liked
·
Most Discussed
·
Fans (33)
·
Preferences
0
Liked
Split function to get values from Comma separated string
0) Begin Insert Into @RtnValue (value) Select Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1))) Set @List = Substring(@List,Charindex(@SplitOn,@List)+len(@SplitO......
Latheesh NK
Posted on Aug 16 2008 7:23AM
Profile
0
Liked
Testing the Linked server connectivity From SQL server 2005
Have you ever encountered a scenario in SQL Server 2000 where you want to test the connectivity of a linked server configuration via TSQL? This was not possible easily and best handled from client side. But we have now a system stored procedure "sp_testlinkedserver" in SQL Server 2005......
Latheesh NK
Posted on Jun 10 2008 5:04AM
Profile
0
Liked
Executing a Job from Query Analyser
Here am going to explain how do we run a job from query analyser. This feature would be helpful at the time of your testing phase of a job. Once we confirmed the desired functionality, we would be able to go ahead and schedule the job. --Use msdb, the proc exists in it use msdb; G......
Latheesh NK
Posted on Jun 9 2008 7:05AM
Profile
0
Liked
Dead Lock Related Topics
Deadlock Notification Deadlocks... huh?? Deadlocks can be a pain to debug since they're so rare and unpredictable. The problem lies in repeating them in your dev environment. That's why it's crucial to have as much information about them from the production environment as possibl......
Latheesh NK
Posted on May 28 2008 5:05PM
Profile
0
Liked
Colasce and ISNULL
Colaesce: Coalesce and ISNULL are SQL server system functions. Both are using to check the null values in the parameters. However there are few differences as follows. 1. Coalesce requires atleast two parameters. Can have n number of parameters. 2. C......
Latheesh NK
Posted on Mar 11 2008 6:49AM
Profile
Previous
1
|
2
|
3
|
4
|
5
Next
Copyright © Rivera Informatic Private Ltd
Contact us
Privacy Policy
Terms of use
Report Abuse
Advertising
[ZULU1097]