Viewing 15 posts - 3,511 through 3,525 (of 49,571 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...
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...
March 1, 2016 at 1:58 am
Jack Corbett (2/26/2016)
February 29, 2016 at 8:33 am
szejiekoh (2/29/2016)
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...
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...
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)....
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...
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...
February 26, 2016 at 2:03 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...
February 25, 2016 at 2:06 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,...
February 25, 2016 at 12:39 am
No, they will run sequentially.
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...
February 24, 2016 at 3:22 pm
Viewing 15 posts - 3,511 through 3,525 (of 49,571 total)