Viewing 15 posts - 13,486 through 13,500 (of 49,552 total)
If SQL's failing abruptly there should be a message somewhere (not the error log that shows the start, the previous one)
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
April 15, 2013 at 3:18 am
rollercoaster43 (4/14/2013)
So you mean to say I can register these 2005 sql servers on a sql 2008 instance and evaluate the Policies from there?
Should work, of course only policies that...
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
April 15, 2013 at 3:18 am
Dree Vasquez (4/14/2013)
What you mean by the the same principal? Is it dbo?
Could be dbo, could be another database principal (owner, not schema)
I cannot modify the stored procedures but I...
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
April 15, 2013 at 3:16 am
Do the report users need up-to-the-minute data? If not, have you considered creating a database snapshot and letting them run their reports off that?
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
April 14, 2013 at 10:56 am
Without seeing the code, this is a guess....
If the user has exec rights on the procedure and the procedure is owned by the same principal as the tables, the user...
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
April 14, 2013 at 4:31 am
Without seeing the exec plan, I'm guessing...
The spools are likely an optimisation for the deleting of the rows from all the nonclustered indexes. You could try dropping the indexes 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
April 14, 2013 at 4:28 am
What's in the SQL error log?
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
April 14, 2013 at 4:27 am
The only way is to evaluate the policies from a 2008 box. That or implement DDL triggers manually to match the policies you want, depending on the policy, that may...
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
April 14, 2013 at 4:26 am
ReadPast = skip locked rows. Also rather bad for accurate results. Find for stuff like dashboards or areas where close to accurate is good enough
If you're having problems with blocking,...
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
April 13, 2013 at 1:21 am
akrounda (4/12/2013)
if you select into the temp table as in the example above will that include the indexes that were in the source tables?
No.
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
April 12, 2013 at 4:39 pm
sqlfriends (4/12/2013)
is that possible because there is not a full backup yet, the transaction log backup will put the database in restoring status.
No.
With no full backup yet, log backups...
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
April 12, 2013 at 4:37 pm
sqlfriends (4/12/2013)
Then after a few hours I logged in again, and see the database is at restoring status.Why is that?
Someone, some job or some application either ran a restore or...
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
April 12, 2013 at 4:25 pm
Did you read the blog post I referenced and all the articles it references?
Basically, you're querying financial data and creating reports that I assume will affect amounts and bills...
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
April 12, 2013 at 4:20 pm
You've got a space before C:. ' C:\' chould be 'C:\' Directories never have a space at the beginning
btw, we're all volunteers here, we all post in our spare time,...
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
April 12, 2013 at 1:19 pm
Partitioning is not (mostly) about performance.
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
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
April 12, 2013 at 10:06 am
Viewing 15 posts - 13,486 through 13,500 (of 49,552 total)