Viewing 15 posts - 3,511 through 3,525 (of 49,552 total)
SELECT CAST('2016' as DATETIME)
SELECT CAST(2016 AS DATETIME)
The first, converting a string to datetime, is assumed to be the first of January of the year specified. The second, converting an integer...
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
March 1, 2016 at 2:54 am
It's not moving to the ELSE block. The error is a parse-time error, happens during parsing before any part of the code, including the IF has executed.
You can see that...
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
March 1, 2016 at 1:58 am
Jack Corbett (2/26/2016)
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
February 29, 2016 at 8:33 am
szejiekoh (2/29/2016)
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
February 29, 2016 at 7:32 am
szejiekoh (2/29/2016)
and what account should we use to install SQL server 2014 then ?
e.g if i use "domain/accountA" 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
February 29, 2016 at 6:09 am
Property unavailable usually indicates a lock and a command timeout. Something had a lock such that it was preventing the file grow. May have been checkDB, may have been something...
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
February 29, 2016 at 3:32 am
2TB is the max size allowable for a log file, so 2TB and unlimited are the same thing.
It wouldn't, by itself, have prevented autogrow (unless the log really was 2TB)....
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
February 29, 2016 at 2:54 am
The broken replication is your problem. You need to fix or remove it, or the log will carry on growing.
And stop messing with the recovery model of the DB. Every...
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
February 29, 2016 at 1:59 am
No it's not. Mirroring requires that the DB be restored WITH NORECOVERY.
Standby does a partial recovery and writes what it rolled back to a file in order to make...
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
February 26, 2016 at 2:03 am
Close enough.
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
February 25, 2016 at 5:53 am
Can you reduce perfmon to a window size you can capture the entire of and repost the screenshot?
Don't uncheck counters, use the highlight option in the toolbar to emphasise the...
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
February 25, 2016 at 2:06 am
5-year old thread
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
February 25, 2016 at 12:40 am
The counter shown in the graph isn't the one you have selected at the bottom. The avg disk sec/read firstly is in red, the counter on the graph is blue,...
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
February 25, 2016 at 12:39 am
No, they will run sequentially.
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
February 25, 2016 at 12:37 am
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
jasona.work (2/24/2016)
/Me leans back, grabs bucket of popcorn
Sure sounds like Gail answered the original question, yet for some reason the OP decided to focus on the...
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
February 24, 2016 at 3:22 pm
Viewing 15 posts - 3,511 through 3,525 (of 49,552 total)