Viewing 15 posts - 12,016 through 12,030 (of 49,562 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...
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...
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...
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.
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
August 21, 2013 at 1:19 am
vinod.saraswat (8/20/2013)
How do you analyze this data i.e.on weekly basis...
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
August 21, 2013 at 1:12 am
Still don't understand what you're asking about.
August 20, 2013 at 12:56 pm
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...
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...
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,...
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,...
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.
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...
August 20, 2013 at 9:09 am
Viewing 15 posts - 12,016 through 12,030 (of 49,562 total)