Viewing 15 posts - 7,531 through 7,545 (of 49,571 total)
Yup, you can restore across the service packs without a problem.
I'm in South Africa, if you are as well, and you would like to set up a retainer for SQL...
October 10, 2014 at 7:42 am
Depends what kind of help you're looking for.
October 10, 2014 at 7:37 am
Or, for multiple levels of geekery in one
October 10, 2014 at 7:33 am
Dave62 (10/9/2014)
According to their example, testing XACT_STATE for != 0 is insufficient.
Only if you plan to COMMIT in the catch block after an error has occurred (which there are...
October 10, 2014 at 7:29 am
No, you shouldn't move the system databases. Script out anything that needs to be copied across.
Also, any plans for upgrading from a 9 year old product (which is out of...
October 10, 2014 at 7:27 am
sqldriver (10/9/2014)
Today it was replacing a traditionalWHERE col IS NULLwithWHERE ISNULL(col, 0) = 0
It's extremely important to realise that those two queries are not equivalent.
The first one...
October 10, 2014 at 6:42 am
Table definition, index definition please?
SQL may well be locking more than one row because it doesn't know that's unique and/or because there's no useful index for it to access that...
October 10, 2014 at 4:39 am
I'd recommend monitoring for a few weeks, see how much of that log is ever used. You can use DBCC SQLPERF(LOGSPACE) for that. With the DB in simple recovery, you'll...
October 10, 2014 at 4:36 am
Koen Verbeeck (10/10/2014)
GilaMonster (10/10/2014)
Large log file will not be the cause of performance problems. Look elsewhere for your performance issues.Managing transaction logs: http://www.sqlservercentral.com/articles/Administration/64582/
What if the log file has to grown...
October 10, 2014 at 4:14 am
Large log file will not be the cause of performance problems. Look elsewhere for your performance issues.
Managing transaction logs: http://www.sqlservercentral.com/articles/Administration/64582/
October 10, 2014 at 3:57 am
Makes no difference what collations you're setting it to. To do as you want specify /SQLCOLLATION=Latin1_General_CP1_CI_AS in the process described on that site.
October 10, 2014 at 3:34 am
Divine Flame (10/10/2014)
October 10, 2014 at 3:22 am
TomThomson (10/9/2014)
GilaMonster (10/9/2014)
Could someone who knows their way around firewalls please help this network admin out?http://www.sqlservercentral.com/Forums/Topic1624301-1550-1.aspx
what he's tring to do (and you said all firewalls should be able to do)...
October 10, 2014 at 2:30 am
Divine Flame (10/9/2014)
October 10, 2014 at 2:26 am
Viewing 15 posts - 7,531 through 7,545 (of 49,571 total)