Your question is quite vague, but here is a good place to start:

http://msdn.microsoft.com/en-us/library/a1904w6t.aspx

Also have a look here:

http://www.developer.com/net/asp/article.php/10917_3761486_1/Working-with-Binary-Large-Objects-BLOBs-Using-SQL-Server-and-ADONET.htm

Actually, you could have the same data, but you're for example using this function in a where clause along with other criteria and one execution plan is hitting a row...

You would need to convert the result of the datediff to a BIGINT before multiplying by 60...these must be long assignments!

E.g.:

ABS(CONVERT(BIGINT,DateDiff(mi, s.dteCrtTS, s.dteAssignEndTS))*60)

If both data types are datetime, then there...

What are the data types of the two input columns in your datediff?

FYI, the problem with the code posted is that you have single quotes around dates in your string - as single quotes signify the end of your string, you have...

Another solution using Row_Number():

;

WITH MyCTEName

AS ( SELECT ImgGroup ,

...

Depending on how often you perform updates to Filestream objects, you should bear in mind that all FILESTREAM objects that have been updated since the last full backup will be...

This is probably a good place to start:

http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated

It's for 2005, but is applicable to 2008 as well (although you'll want to reference the 2008 dll's in your project).

It gives an...

Things I usually check on a client site are:

Tempdb and other system databases on the C: drive - these can (and should) be moved away from the system partition

The Windows...

You can find most of the information in the sys.servers view to build a script for this.

Otherwise you could use SMO to script this programatically.

If they are static, you...

Well, your requirements are well within the limitations of SQL Server Express edition, (the R2 version supports up to 10GB) so is it an option to install this on the...

Confirmed:

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

Msg 0, Level 20, State 0, Line 0

A...

He...

Assuming you're connecting to the correct server, are you using 2005 or 2008 BIDS? The version of the SQL Client provider that ships with 2005 isn't compatible with the merge...

Doesn't really answer why you need one particular metric to be below an arbitrary number...

Could you post the actual execution plan, otherwise we're all guessing.

Couple of obvious things, but:

1. Could...