|
|
-
Nakul Vachhrajani Posted 20 Days ago through Blogs
Most database documentation and code fail to address name resolution errors – i.e. the ability to ensure that a name uniquely identifies a database object. This post provides an introduction to four-part, three-part and two-part database object naming c...
|
-
Nakul Vachhrajani refreshed 21 Days ago through Blogs
Recently, I was working with a developer colleague of mine to troubleshoot an issue he had with one of his queries. A stored procedure he wrote was consuming data from another procedure and was not functioning as expected. I suspected the issue to be a ...
|
-
Nakul Vachhrajani Liked 21 Days ago through Blogs
Recently, I was working with a developer colleague of mine to troubleshoot an issue he had with one of his queries. A stored procedure he wrote was consuming data from another procedure and was not functioning as expected. I suspected the issue to be a ...
|
-
Nakul Vachhrajani Commented 21 Days ago through Blogs
Hello, Ramkoti!
The screenshots in this post are from a SQL Server 2012 (CTP) instance. The instructions for the RTM release are also similar. What is the exact confusion that you are having? Maybe that will help me help you out in a better way....
|
-
Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing SQL Server Performance” with Patrick O’Keeffe who is Director of Software Development at Dell Software Group. I must say, it was a really interest...
|
-
Nakul Vachhrajani Commented 24 Days ago through Blogs
An interesting implementation and another reason to back my belief that every database must have a look-up or a tally table of some sort. Thanks for sharing, Madhivanan!...
|
|
|
|
|
-
Nakul Vachhrajani Commented 24 Days ago through Blogs
Hello, Sheldon! You should be able to do this via Syndication. You can request a new syndication from the Syndicated Blogs page at: [http://beyondrelational.com/modules/24/syndicated.aspx?s=stream&tab=posts][1]. Hope it helps and welcome to the BR commu...
|
-
Nakul Vachhrajani Liked 1 Months ago through Blogs
Have you ever tried to write T-SQL code that conforms completely to the ISO standard? Since Microsoft SQL Server's T-SQL standard is based on the ISO standard, doing so is quite possible. Today, I explore the ISO equivalents of the EXISTS keyword - SOME...
|