Viewing 15 posts - 5,716 through 5,730 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2015 at 2:52 am
When the log backup runs.
http://www.sqltechnet.com/2015/01/transaction-log-backups-on-availability.html
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2015 at 12:57 pm
Ozzmodiar (6/2/2015)
Will they just grow, grow and grow?
No.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2015 at 7:24 am
rodjkidd (6/2/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2015 at 6:13 am
Run a checkDB on Msdb.
You are running CheckDB regularly on all databases, right?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 1, 2015 at 9:20 am
Viewing 15 posts - 5,716 through 5,730 (of 49,552 total)