If you use that query a lot, you might want to turn it into a view, make a cross join. You can then treat it like a normal table. and...

There will be five individuals inserting data into the table.  Each entry should automatically display the next increment number available for input.  No user will have their own sequence of...

I couldn't see any reason why that would be the case (unless you were joining on a varchar(2000) column for example).

A join is fastest when the column is a primary key clustered...

Always use DATEDIFF to compare/add/subtract dates. 

datetime and smalldatetime data types are not numbers, so SQL Server doesnt know what you are thinking when you say WHERE date - date > 14...

SQL Sever and SQL Agent run as Windows Services. Starting and stopping windows services is done according to windows permissions and has nothing to do with sql users. Even though...

SQL Server has IDENTITY to do autonumbers. It can only be used with an int data type, but you could create a computed column to return the identity + year...

1) dbo is a user, while db_owner is a role. There are subtle but important differences.

To learn more about permissioning and ownership in SQL Server, I'd recommend reading through all...

mmm Microsoft must have forgotten to increase the build number for SP3a, despite some of the added fixes, SP3 and SP3a report the same version (8.00.760). The only way to...

The N before the quotes says that the text inside the quotes should be treated as unicode.

If you ever start working with something funky like Japanese text in your...

Oh this is a fun one, cause cursors are soooo slow.

Here's s snippet of code from a routine i use that loops through the...

Check out SELECT ... FOR XML . The syntax is a little tricky, but your entire results set will be returned as an xml document, in the formatting you supply....

Hey Chris

VB.Net I'm not to familiar with (I use C#), but the .Net data objects are the same. Some tips to help you on your way:

• To access SQL Server you...

BULK INSERT runs under the security context of SQL Server.

bulkuser is the owner of your table, and dbo is the owner of your sproc. Two different security accounts. If...

Ah... Changing SQL Servers default options on system databases can only lead to trouble, or in some cases instant death.

Leave them as they are. Master really only needs backing...

Hey Jdalonzo

I work with tables that typicaly get Millions of rows inserted into them at a time. BOL and I suggest dropping and recreating the clustered index if:

As a...