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)
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...
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...
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?
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...
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...
April 14, 2013 at 4:28 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...
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,...
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.
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...
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...
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...
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,...
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/
April 12, 2013 at 10:06 am
Viewing 15 posts - 13,486 through 13,500 (of 49,552 total)