Viewing 15 posts - 871 through 885 (of 1,192 total)
What do you mean by "crash"? What's the exact error message you're receiving?
Cheers!
August 12, 2015 at 7:16 pm
Yes, the same logical file names can be used in multiple databases. I've actually seen instances with hundreds of databases that all have the same logical file names because new...
August 12, 2015 at 4:15 pm
Naveen PK (8/12/2015)
Jacob Wilkins (8/12/2015)
August 12, 2015 at 1:02 pm
These questions are always fun, since I have to do some playing with binary representations to make sure I fully understand what's going on. Fortunately in this case it's pretty...
August 12, 2015 at 11:35 am
That suggests you have kms_quoteorder values that do not contain a '/'. In that case, charindex would return 0, and after subtracting the 1 would give -1, which is indeed...
August 10, 2015 at 2:32 pm
First, very nice question! I rather like these sorts of questions as opposed to the "Here's a script, what's the result of the last SELECT?" questions. While the latter sort...
August 6, 2015 at 12:43 pm
Jacob Wilkins (8/3/2015)
Indeed. On a couple million rows, that typically shaves some tens of milliseconds from the duration compared doing the math on the date first. Prior to 2012, you...
August 4, 2015 at 9:48 am
djj (8/3/2015)
I have had luck with
DECLARE @Date DATE = '1/1/2015', @Time TIME = '15:20'SELECT cast(@Date as datetime) + cast(@Time as datetime)
Indeed. On a couple million rows, that typically shaves...
August 3, 2015 at 12:21 pm
Hmmm...I'm a little confused about the purpose of this code.
First, the WHERE clause filters results to rows that have a particular ORDERID, and then you SELECT DISTINCT ORDERID, so you...
August 3, 2015 at 9:00 am
Even more interesting! I'll have to do a sanity check when I get home; what's your exact build of 2008 R2?
EDIT: I did my sanity check. I get the expected...
July 31, 2015 at 6:06 pm
Interesting. I've run it on a 2008 R2 instance, and I get the expected behavior.
Are you definitely taking the actions in this order?
1)Create/populate ##tmptest in Query1
2)Run SELECT...
July 31, 2015 at 5:32 pm
In addition to the good feedback you've already gotten from Gail and Scott, I figured I'd try to explain the probable cause of the issue you're seeing.
In your code, the...
July 31, 2015 at 2:38 pm
Luis Cazares (7/31/2015)
The Dixie Flatline (7/31/2015)
Alvin Ramard (7/31/2015)
Luis Cazares (7/31/2015)
WayneS (7/31/2015)
Looks like Luis is answering Oracle questions now.
That wasn't the only attempt on that day. Here's a completely lost Oracle...
July 31, 2015 at 12:34 pm
The short answer is that the 10:30-10:35 log would not be used with the 10:00-10:45 full. The easy way to think of it is that the restoring the full backup...
July 31, 2015 at 12:10 pm
Yes, it backs up directly from SQL Server, and restores directly to it (it just connects and issues BACKUP and RESTORE commands like you or I would).
Backing up/restoring that much...
July 31, 2015 at 9:51 am
Viewing 15 posts - 871 through 885 (of 1,192 total)