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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2013 at 4:29 am
Yes. Optimise queries, tune indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2013 at 3:14 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2013 at 3:09 am
Fine, you're right, I'm wrong, etc, etc.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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'.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 10, 2013 at 10:35 am
Is the service running?
Are you specifying the correct server and instance name?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 9, 2013 at 12:03 pm
Viewing 15 posts - 13,951 through 13,965 (of 49,552 total)