Viewing 15 posts - 47,311 through 47,325 (of 49,552 total)
In SQL 2005's profiler's create trace dialog, on the second tab (event selection) there's a button at the bottom 'Column Filters' That will let you set whatever filters you like.
You...
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
February 21, 2008 at 11:09 pm
The name that you get from sysindexes.
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
February 21, 2008 at 10:59 pm
cheungh (2/21/2008)
4) create a new xyz.log file for the database
No need to do anything with any logs if you're emptying data files
Any links to the command empty using DBCC.
Books Online...
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
February 21, 2008 at 10:56 pm
Since they are the same filegroup, you probably need to run the DBCC SHRINKFILE with the EMPTYFILE option.
EMPTYFILE migrates all data from the specified file to other files in...
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
February 21, 2008 at 1:11 pm
It's not possible of SQL 2000. To use profiler, you must have sysadmin rights
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
February 21, 2008 at 1:05 pm
Probably not with SSIS.
Are there different filegroups, or are all the files part of the same filegroup?
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
February 21, 2008 at 11:13 am
Import the trace into a DB table, then query it for any rows where TextData Like '%alter%' and TextData Like '%database%'
It may take a while, but it'll be faster than...
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
February 21, 2008 at 11:00 am
Please can you post the table structure, some sample data and the expected results. It makes it much easier for us to answer your question.
Ref: http://www.sqlservercentral.com/articles/Best+Practices/61537/
Thanks
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
February 21, 2008 at 10:59 am
😀 I'm gonna be thinking of Star Wars every time I look at SQL 2008 now.
I foresee a while new set of abuses of query hints coming up soon.
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
February 21, 2008 at 10:49 am
I should have thought of that earlier.
Those aren't indexes. They're automatically created column statistics. The query optimiser creates those to better know the data distribution within a column.
You can drop...
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
February 21, 2008 at 10:18 am
I know you haven't created any inde3xes. I'm trying to identify what the entries in sysindexes are and how they got there.
Please run the following query and post the results...
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
February 21, 2008 at 2:58 am
No, no, no. I didn't mean delete from the system table. That's guaranted to stuff things up.
I meant drop the index.
DROP INDEX <TableName>.<IndexName>
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
February 21, 2008 at 12:40 am
If you try to drop one of those indexes that appears in sysindexes for that table, what happens?
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
February 21, 2008 at 12:13 am
Please don't post multiple threads for the same problem
Replies to the following thread please - http://www.sqlservercentral.com/Forums/Topic458367-5-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
February 21, 2008 at 12:10 am
Strange.
Can you run a checkDB on that database? See if there's any form of corruption.
Do you know if anyone there does direct updates of the system tables? check if updates...
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
February 20, 2008 at 11:46 pm
Viewing 15 posts - 47,311 through 47,325 (of 49,552 total)