Viewing 15 posts - 15,361 through 15,375 (of 39,970 total)
Note if you set this behavior then you have to make sure all your code includes commits. Otherwise you will have severe locking/blocking issues.
Most SQL Server code does not expect...
September 2, 2011 at 9:45 am
No.
Short answer is that you don't want to shrink data files (MDF/NDF) unless some unusual event caused them to grow and the data space isn't needed.
You've listed two things that...
September 2, 2011 at 9:41 am
James and Paul have noted the correct response. You cannot estimate log file size, any rule of thumb is a wild guess based on experience, but could be completely inappropriate....
September 2, 2011 at 9:38 am
if (select myval from Mytable) is null
insert into ...
else
insert into
...
will work, but you have two tag_names in the different code. What do you mean...
September 2, 2011 at 9:33 am
As we were getting the kids ready this am, a family of deer (buck, doe, 2 kids) walked through the front yard. The girls were fawning over them at the...
September 2, 2011 at 9:11 am
mtillman-921105 (9/1/2011)
jcrawf02 (9/1/2011)
I heard there's some crazy SQL guy who will let you stay in one of his stables if you're willing to shovel...
That's funny because horses and I do...
September 1, 2011 at 1:19 pm
mattech06 (9/1/2011)
Is...
September 1, 2011 at 12:25 pm
We've negotiated to rent a room from PASS and will have a casino party/Exceptional DBA awards.
We are subsidizing some of it, and we'll sell $20 tickets in advance. Announcement will...
September 1, 2011 at 9:40 am
It's on!
Starting a new thread in this forum for Fantasy Football 2011.
September 1, 2011 at 9:31 am
If you could check the option, you're forcing a password change, however that's a security risk. Imagine the password is compromised. You check the box, the hacker logs in first,...
September 1, 2011 at 9:25 am
I have seen a concert at Red Rocks (John Mayer/Maroon 5) and also been there a few times with family to walk, but haven't fun the steps. Not sure my...
September 1, 2011 at 9:03 am
mtillman-921105 (9/1/2011)
'Can't wait. Memphis just isn't were I want to be anymore. I have some family and friends here, but most have moved on....
September 1, 2011 at 8:46 am
It looks that way on mine, but if I change the password, I can then check the box. You can't force a password change without changing the password.
September 1, 2011 at 8:36 am
Without seeing the DDL for the tables and knowing the keys, it's hard to give you the exact.
In terms of conditions, use them in a WHERE, something like
WHERE dbstatusID !=...
September 1, 2011 at 8:26 am
jcrawf02 (9/1/2011)
Wow, this is a great idea. Someone should do this for SQL
Interesting. I think we're not consistent, but I do see a lot of
- #sql
- #sqlserver
- #sqlhelp
- #sqlsat
- #sqlpass
-...
September 1, 2011 at 8:17 am
Viewing 15 posts - 15,361 through 15,375 (of 39,970 total)