Viewing 15 posts - 13,951 through 13,965 (of 49,552 total)
jerry209 (3/10/2013)
Also,comparing the above query with the one mentioned below,which query is more appropriate(best practice).
Both will perform pretty horrid on larger tables. You're looking at table scans to resolve either.
Is...
March 11, 2013 at 4:38 am
Only time a trigger will be disabled is if someone goes in and disables it.
Triggers shouldn't be the first choice, if a problem can be solved without a trigger then...
March 11, 2013 at 4:29 am
Creating a clustered index does take a lot of time, you're recreating the table.
Drop all nonclustered indexes before you start, put them back once you're done, that'll save a bit...
March 11, 2013 at 3:13 am
Maybe, maybe not.
Does the app depend on some behaviour in a lower compat mode? Will the app break if you change the compat mode?
March 11, 2013 at 3:11 am
UncleBoris (3/10/2013)
I then thought, well why not do all log backups using COPY_ONLY and then never have to worry about a lost or corrupt backup again!!!
Because copy_only log backups don't...
March 11, 2013 at 3:09 am
Fine, you're right, I'm wrong, etc, etc.
March 10, 2013 at 2:15 pm
Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel of 'do this for me'.
March 10, 2013 at 1:28 pm
Paul_Data_Smart (3/10/2013)
And recieved the following notification "Your evaluation edition of SQL Server has ended"
Yes, that'll be the cause. Evaluation's expired, service won't be running. You'll need to install a full...
March 10, 2013 at 10:35 am
Is the service running?
Are you specifying the correct server and instance name?
March 10, 2013 at 6:09 am
Paul_Data_Smart (3/10/2013)
How do I disable a remote connection.
Why do you want to disable remote connections? Eval should have then pre-enabled iirc.
March 10, 2013 at 5:04 am
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections
Have you done that and...
March 10, 2013 at 4:37 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1428965-391-1.aspx
March 10, 2013 at 4:36 am
The sharepoint database design is pretty bad (very bad), and about the only way to make the queries work acceptably is to force maxdop 1.
March 9, 2013 at 3:29 pm
Pretty much.
The DB was in full recovery, any query you run will tell you that, just in the absence of a full backup there's nothing to base log backups on...
March 9, 2013 at 12:03 pm
Viewing 15 posts - 13,951 through 13,965 (of 49,552 total)