Viewing 15 posts - 36,781 through 36,795 (of 49,552 total)
I would suggest either SSIS or bcp (if it's to be a repeated task) or the import/export wizard if it's once-off.
With bcp you'd have to bcp the data to a...
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 27, 2009 at 9:49 am
Anytime an index is moved to another filegroup all the pages that comprise that index are moved, root, intermediate ane leaf levels. This applies to clustered and nonclustered indexes alike
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 27, 2009 at 9:45 am
A restart of the service or the execution of sp_cycle_errorlog. Easy to tell which, check the beginning of the error log, if the SQL startup messages are there then it's...
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 27, 2009 at 8:52 am
Lynn Pettis (8/27/2009)
This time an OP took exception to Gail's answer.
I wonder how long he's going to protest.
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 27, 2009 at 8:46 am
thomas.garay(8/27/2009)
It must be able to be done some how...
It's not possible. Files and filegroups are intrinsically linked to the databases that they are part of and there is 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
August 27, 2009 at 8:39 am
thomas.garay (8/27/2009)
I need helkp in figuring out how to move an NDF file from a DB to a totally different DB.
Cannot be done.
You will have to read the...
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 27, 2009 at 8:04 am
Create a transactional replication publication with at least one article in it. Once you've gone all the way through the wizard and the publication has been created, drop the publication...
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 27, 2009 at 8:01 am
You should be able to do that, as long as you exclude the ntext column. That's got damaged pages and there's no way SQL's going to read those. But then...
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 27, 2009 at 7:59 am
Amit Singh (8/27/2009)
my understanding is that clustered index only has column data not the row
The leaf level has the entire row, the non-leaf levels have just the clustering key
.... else...
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 27, 2009 at 7:25 am
Ness (8/27/2009)
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 27, 2009 at 7:23 am
Mostly the same rules apply to dynamic SQL as to normal code. Make sure that the query can use indexes, make sure that there are appropriate indexes.
I really can't say...
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 27, 2009 at 7:09 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic777774-145-1.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 27, 2009 at 7:02 am
Personally I mostly use % idle time, avg sec/read and avg sec/write. Doesn't matter what the underlying storage is, if the idle time is low and the sec/read or sec/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 27, 2009 at 6:59 am
FredS (8/27/2009)
I would pass @Area and @Area_key to the Stored Procedure and it would return the same fields, but based on differing criteria.
Not a good idea. There's a number of...
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 27, 2009 at 6:42 am
There's a couple of tricks to doing this in SQL 2005 and below, but there's no easy way of doing it.
One option is to create an indexed view that filters...
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 27, 2009 at 6:41 am
Viewing 15 posts - 36,781 through 36,795 (of 49,552 total)