While the operators used to be a big deal in SQL Server 7, the relevance and optimization of the query optimizer is not longer closely established. For example, it used to be faster to create a join table when multiple arguments were desired for an a...

While the operators used to be a big deal in SQL Server 7, the relevance and optimization of the query optimizer is not longer closely established. For example, it used to be faster to create a join table when multiple arguments were desired for an a...

Very Cool!...

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Madhivanan... Nice article. re: When an object name contains a space, special character, etc, the only way to express them is to put them aroud squre braces Not true. You put square braces around the special name, not the other way around. A...

Madhivanan... Nice article. re: When an object name contains a space, special character, etc, the only way to express them is to put them aroud squre braces Not true. You put square braces around the special name, not the other way around. A...

Nicely written. I actually came to your blog based on the topic...most developers aren't even aware that tempdb is instantiated based on the current Model db configuration. I have never had a model database with large file sizes because that is so...

Nicely written. I actually came to your blog based on the topic...most developers aren't even aware that tempdb is instantiated based on the current Model db configuration. I have never had a model database with large file sizes because that is so...

This is an excellent question! There are frequently things that need to be done interacting with SQL Server, and things that are outside SQL Server. Since PowerShell has the ability to interact fully with SQL Server through SQLDMO as well as other me...

It is an even better practice not to name a stored procedure after a reserver or key word in SQL...