Viewing 15 posts - 5,716 through 5,730 (of 49,571 total)
sunshine-587009 (6/2/2015)
Ok. Thank you.I was trying to change the IF to a CASE.
CASE WHEN @Variable IN ().
IF and CASE are not interchangeable. IF is used for control flow. Case is...
June 3, 2015 at 2:53 am
nagraj275 (6/3/2015)
hi sunshine i hope this case statement work
It won't, because as Lynn said above, CASE is not used for control flow in SQL Server.
If you'd tried to...
June 3, 2015 at 2:52 am
When the log backup runs.
http://www.sqltechnet.com/2015/01/transaction-log-backups-on-availability.html
June 3, 2015 at 2:44 am
WhiteLotus (6/3/2015)
GilaMonster (6/2/2015)
Run a checkDB on Msdb.You are running CheckDB regularly on all databases, right?
I don't do DBCC in my servers honestly .
What???
You prefer to find out about corruption...
June 3, 2015 at 2:33 am
I'm guessing that google.com is down today. At least the za one still works fine, so I can google for anyone affected by this terrible outage.
June 2, 2015 at 12:58 pm
susan.wong (6/2/2015)
i'm leaving sql and wants to know what store procedure do? thanks
Whatever the person who created it wrote it to do. It's like a module or procedure in any...
June 2, 2015 at 12:57 pm
Ozzmodiar (6/2/2015)
Will they just grow, grow and grow?
No.
June 2, 2015 at 12:55 pm
Here? If google doesn't help and the answer isn't in the Books Online for SQL 2016 (BoL was available on the MSDN site before the CTP was available)
June 2, 2015 at 7:24 am
rodjkidd (6/2/2015)
June 2, 2015 at 6:13 am
Run a checkDB on Msdb.
You are running CheckDB regularly on all databases, right?
June 2, 2015 at 2:28 am
Clustered columnstore or nonclustered columnstore?
Nonclustered columnstore indexes still make the table read-only in SQL 2014. You can do tricks with switching partitions in to the table with the columnstore if...
June 2, 2015 at 2:27 am
spaghettidba (6/1/2015)
Use it for whatever your system is hitting harder on random I/O.Typically it can be tempdb, but a problematic filegroup can be even a better fit for SSDs.
Yup, this...
June 1, 2015 at 10:11 am
Now that looks a bit more sensible.
Don't try to debug as a whole. Work in small pieces, make sure that each small piece works, repeat until everything is working correctly....
June 1, 2015 at 9:57 am
No, still doesn't make sense.
You're joining a table to itself, with a filter that cannot return any rows, then trying to insert back into the exact same table...
I think you...
June 1, 2015 at 9:37 am
I don't understand what you're trying to do here
SELECT T.logTime, T.filePath, T.fromServer, T.toServer, T.service, T.messageId
FROM QABSNew T
LEFT JOIN dbo.QABSNew E on T.logTime = E.logTime
WHERE ISNULL (E.logTime, '') = ''
Why are...
June 1, 2015 at 9:20 am
Viewing 15 posts - 5,716 through 5,730 (of 49,571 total)