Viewing 15 posts - 12,016 through 12,030 (of 49,552 total)
Even if it was from an earlier version, page verify would not be off. If it was upgraded from SQL 2000 and that setting not changed, it would be page...
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
August 22, 2013 at 3:30 am
cmerrell (8/21/2013)
But "insert into" will only insert into an existing table. What about creating a new table?
CREATE TABLE ...
INSERT INTO
EXEC ...
Caveat is that you have to know the structure...
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
August 22, 2013 at 3:28 am
SQL has no knowledge whatsoever about RAID caching. It assumes when it issues a read that the read comes from disk and it assumes that when it issues a write...
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
August 21, 2013 at 12:55 pm
Someone turned it off at some point after creating the database (first creation). When, that's going to be very hard to tell, if not impossible.
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
August 21, 2013 at 7:31 am
Restart SQL is the solution. DO NOT attempt to kill the windows thread, it cause stack dumps, kill the SQL process, break all sorts of things
http://sqlblog.com/blogs/linchi_shea/archive/2010/02/04/killing-a-sql-server-thread-don-t.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
August 21, 2013 at 1:19 am
vinod.saraswat (8/20/2013)
How do you analyze this data i.e.on weekly basis...
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
August 21, 2013 at 1:13 am
Potentially quite a lot, but as I said, most people ignore this recommendation and use one account for every single SQL Server service they have.
http://msdn.microsoft.com/en-us/library/ms144228%28SQL.105%29.aspx#isolated_services
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
August 21, 2013 at 1:12 am
Still don't understand what you're asking about.
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
August 20, 2013 at 12:56 pm
What do you mean 'shortcut for'?
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
August 20, 2013 at 11:04 am
Grant Fritchey (8/20/2013)
I meant, why would you create your own snapshot first?
I wouldn't.
Only reason maybe is if the drive with the data files on is nearly full and there's enough...
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
August 20, 2013 at 9:49 am
Sean Lange (8/20/2013)
GilaMonster (8/20/2013)
A CTE however, despite its name, is not a table and hence can not have anything inserted into it.
Acutally you can insert into a cte, just like...
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
August 20, 2013 at 9:25 am
Depends. Mostly on what you're trying to figure out.
To give you an idea, I have a client with a moderatly busy database that, if I trace for stored procedure completes,...
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
August 20, 2013 at 9:23 am
Grant Fritchey (8/20/2013)
GilaMonster (8/20/2013)
Grant Fritchey (8/20/2013)
I thought the internal/hidden snapshot was a different critter than the snapshots we create. But, hey, happy to be wrong.
No, the same thing, same behaviour,...
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
August 20, 2013 at 9:14 am
Well, different accounts for different services is the standard recommendation. I know most people just ignore the recommendation though.
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
August 20, 2013 at 9:10 am
Grant Fritchey (8/20/2013)
I thought the internal/hidden snapshot was a different critter than the snapshots we create. But, hey, happy to be wrong.
No, the same thing, same behaviour, same mechanics.
The only...
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
August 20, 2013 at 9:09 am
Viewing 15 posts - 12,016 through 12,030 (of 49,552 total)