Steve Jones - SSC Editor (2/2/2012)

Maybe, but there is a large, very active SQL Server community on twitter and we use it daily to bond,...

USE master;

GO

EXEC sp_attach_single_file_db @dbname = 'YourDatabase',

@physname = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\YourDatabase_Data.mdf';

make sure there isn't a YourDatabase_log.ldf in there

OR

USE [master]

GO

CREATE DATABASE [YourDatabase] ON

( FILENAME =...

Yea just delete that log file (or move it) and try again.

I've gotten that error before. Quick easy fix.

Where did you get your mdf from? Was it a clean shutdown?

If so, you can try sp_attach_single_file_db or CREATE DATABASE [dbname] FOR ATTACH

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

@Jeff, your audience must be on a more advanced level than mine here. I usually have to explain even the concept of a common table expression: "It's almost like a...

Highly offended. :angry:

Just kidding. I was fine back on the second or third post. You guys kind of blew it up (like that rbar picture).

It's been an enjoyable read though.

I see your point but at the same time they have removed other functions that I HAVE used.

I guess this one can't really be replaced.

thanks for your insight though.

I was just going for 3 variables but I do appreciate the explanation.

So if ALL isn't useful. Why still keep it around? MSSQL is released every couple years. You'd...

Thanks Sean, but I'm not sure that would work.

DECLARE @a int = 123,

@b-2 int = 0 ,

@C int =102733019

select case when

...

Oh good ol proofs. Discrete math, how I miss thee.

I need to have the logic in place so that if one is zero, the whole thing still works. Like this:

DECLARE...

After reading this and trying it out, I not only got it to work, I even understand it!

Even though it's an old topic, it helped me out a lot.

Thanks people!

On that note make sure that it's 'reason' and not "reason" in the SP's

SET QUOTED_IDENTIFIER ON could make that blow up.

It might be worth it to set up profiler and...

mosaic-287947 (5/30/2011)

I admire your self-confidence but (with...

I think DBAs are going to have to learn BI. I recently went to a MS BI conference and learned a lot.

It was a little wake up call though when...

Actually I fixed this problem. I added an index on the table that I used in the function. This sped things right back up.

Have you tried adding some indexes?