Viewing 15 posts - 16,846 through 16,860 (of 22,226 total)
I have yet to put this into production, but in the dev & test servers where I've been using compression there are many positives regarding reads. The writes don't seem...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 7:35 am
bhavesh_183 (7/30/2009)
I have fairly huge table having 1 million records. The table has a binary tree structure.
I want to write a procedure for getting all the children records for...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 7:14 am
Since the query is currently running, you may need to use sys.dm_exec_requests. This will provide you with a current statement start & end offset so that you can see which...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 7:00 am
It depends on what you want to do. You can use sqlcmd to run command line scripts to move data from 2008 to 2000 & vice versa. SSIS will work...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 6:56 am
To answer the question, it's going to be approximately a wash. Replace acts as a drop & recreate.
But, I'd suggest pursuing what happened as well. What do the consistency checks...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 6:50 am
Glad to hear it's fixed. I don't think you did what I was going to suggest, clean out the registry & then try the reinstall. I had to do that...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 6:49 am
To my knowledge, they'll see some of the other databases available in the server, but they'll only be able to connect to and perform actions on the db's that you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 6:46 am
jswong05 (7/16/2009)
2005 has missing index DMVs and DMFs, I use them.:-P:cool:
But you test their results, right? Those things are notorious for suggesting poor choices on indexes. You need to exercise...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 5:41 am
bhuvnesh.dogra (7/30/2009)
While browsing to HKEY_LOCAL_MACHINE>>software>>microsoft>>microsoft sql server
in the instance folder "REPORT_DEV"
REPORT_DEV>>MSSQLSERVER>>SuperSocketNetlib folder
therer should be one more folder "Tcp"
can u please tell me how can i generate...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 5:38 am
gochaithu (7/29/2009)
I have some doubt's in preparation of Online Exam database.My first doubt is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 5:34 am
Amit (7/29/2009)
Hi Grant,As admitted by you its the hard way, so this is not preferrable and also it can result in loss of data....
Thanks,
Amit
Too true, but I always like to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 30, 2009 at 5:30 am
I've never run into that one before. It sounds like a bug or possibly a coding error.
I'm recreating databases pretty regularly in 2008 and I haven't seen this. Just a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 12:14 pm
Luke L (7/29/2009)
Anyone else see anything odd about this person's posting history?http://www.sqlservercentral.com/Forums/UserInfo816418.aspx
:sigh:
Not really, no.
But you know, I was just thinking... If I had RAQ Report, I think it would solve...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 9:27 am
Since someone else may have the same problem and find this thread, can you post your solution?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 9:01 am
Thanks Roy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 8:33 am
Viewing 15 posts - 16,846 through 16,860 (of 22,226 total)