2010-11-26
3,114 reads
Arup Chakraborty
2010-09-10 (first published: 2008-11-17)
33,016 reads
2010-01-20
4,576 reads
4 Ways to Increase Your Salary (Using UPDATE)
This article depicts how to approach row by row updates needed in a salary table. It might not directly let you increase your salary, but it could help you at review time.
2009-11-26
43,004 reads
2009-10-27
3,815 reads
Twenty tips to write a good stored procedure
This article will provide some useful information to write a SP. I have emphasized on performance.
2009-08-10
53,644 reads
2009-02-24
4,134 reads
2008-12-03
3,704 reads
2008-11-19
3,156 reads
2008-11-13
3,095 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers