Yes, provide sample data etc

Else:

SELECT

'number of 50s' as [Measure]

, COUNT(myCol) as [Value]

FROM myTable

WHERE myCol = 50

UNION

SELECT

'number of 100s' as [Measure]

, COUNT(myCol) as [Value]

FROM myTable

WHERE...

You could possibly create a SSIS package to load the data/images into your table using foreach elements.

But this is really only worthwhile if this is going to be a recurring...

You will need to provide more details - SharePoint relies on a number of underlying databases, if you want to rebuild the indexes within those databases, you probably can ......

A view is exactly that, a constructed view of the underlying tables, essentially a saved or materialized SQL (SELECT) query.

If you want to truncate the view, then really you should...

Have a look at this:

http://www.sqlservercentral.com/blogs/practicalsqldba/2012/03/15/importing-images-to-sql-server-database-using-t-sql/

In your case, you may want to adapt it slightly to match your KeyID with image name, but it should get you started.

Also check if you...

Not dependant on the OS as such - however keep in mind that the max memory that can be used on Windows Server 2003 is 512 GB; and on Windows...

I would create 2 select statements as subqueries in your main query and join them using the columns that you know must be equal to uniquely define a record and...

In terms of measuring the improvement, simply run a (typical) query before setting the DB to read only and measure the CPU impact etc ...

Then set your DB ot RO...

With recompile, you are telling SQL Server to throw away the existing query plan and build another one but only for this once.

With parameter sniffing, the optimizer pretends that the...

I would suggest putting the DB into single user mode and run your scripts - but you do need to send out some kind of warning to the users I...

Hi,

I remember viewing this video on Channel 9 a little while ago and found it very interesting and it helped me lots to understand the differences between Oracle and SQL...

you need a comma before the word CASE

and you might as well add AS [myColumnName] after END to give a column name to the third column.

B

Hi,

Not entirely sure I understand your question, but I think you need to look at the CASE statement.

e.g.:

SELECT col1

, col2

, CASE WHEN (col1 + col2) = 42 THEN 'Department' ELSE...

Hi,

you could use the script @:

http://blogs.technet.com/b/mdegre/archive/2009/10/14/determining-sql-server-table-size.aspx

Ensure that the data is stored in a persistent table instead of a #temp table.

Then you can also setup a SQL job to run the...

Hi,

you need to place your question in the SQL Server 2005 forum (http://www.sqlservercentral.com/Forums/Forum338-1.aspx instead of the 2008 forum.

B