Viewing 15 posts - 43,471 through 43,485 (of 49,552 total)
One of my developers has written a query that when runs seems to be spawning some sub-queries (I say this because when I look in activity monitor I see multiple...
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
October 28, 2008 at 10:21 am
What do you mean by 'its still a SQL 2000 database'? If you mean it's still in compat mode 80, that's normal. The upgrade will not change the compatibility mode...
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
October 28, 2008 at 10:17 am
The RPC:completed and SQL:Batch completed are good events to use to see what's running against the server.
First thing is to capture whatever code the app is using to show 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
October 28, 2008 at 10:13 am
rchantler (10/28/2008)
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
October 28, 2008 at 10:09 am
Lowell (10/28/2008)
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
October 28, 2008 at 6:56 am
Try this
SELECT A, B, C, Row_number() OVER (Partition by A, B, C Order by A,B,C) AS Flag
FROM
(SELECT A,B,C FROM OriginalTable
union all
SELECT A,B,C FROM OriginalTable
union all
SELECT A,B,C FROM OriginalTable
union all
SELECT...
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
October 28, 2008 at 6:55 am
Leo (10/28/2008)
Some of my table are 'NULL' in statistics_Update_Date column, is that mean UPDATE STATICS is never been run?
More likely it means that the object in question is a heap...
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
October 28, 2008 at 6:52 am
In SQL 2005 you can set up DDL triggers to log schema changes.
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
October 28, 2008 at 6:48 am
Why are you shrinking your database?
Be aware that you will need to rebuild indexes afterwards as the shrink will badly fragment them.
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
October 28, 2008 at 6:47 am
Considering that you want to import from a text file into SQL, perhaps the data source should be the text file you're trying to import.
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
October 28, 2008 at 6:37 am
Check the account you're using to connect. Make sure that the login name exists on the remote server and the password is correct.
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
October 28, 2008 at 6:36 am
Leo (10/28/2008)
Thanks. I add another maintenance plan for transaction log only.
You need to have them in different plans because they have to run at different intervals. Remember what the point...
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
October 28, 2008 at 6:36 am
No. I mean the import/export wizard
From object explorer in management studio, right click a database, select tasks, select Import Data
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
October 28, 2008 at 4:19 am
You can't backup the log of a database in simple recovery mode. The point of simple is that the log is not retained and backups of it are not required.
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
October 28, 2008 at 4:18 am
What's your reason for clustering? What are you trying to gain?
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
October 28, 2008 at 4:16 am
Viewing 15 posts - 43,471 through 43,485 (of 49,552 total)