Viewing 15 posts - 43,591 through 43,605 (of 49,552 total)
Performance testing code before deploying to production.
I got very tired of devs deploying code to prod without doing any form of performance testing on it. The code frequently performed terribly...
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 24, 2008 at 4:01 am
Interesting. All of the branches are the same spid. I think this is a parallelism deadlock. Did you read the blog post I linked above?
Other thing to note is that...
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 24, 2008 at 3:27 am
victor_bosc (10/23/2008)
I think that I have a problem with the full backups because the backup process used to take between 45 and 60 minutes.Now, it is taking between 2 and...
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 24, 2008 at 3:14 am
john (10/23/2008)
Yes I would love to learn how to write it better but I am still a noob and learning.
Best practice - all data access via stored procedures. Parametrise 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 24, 2008 at 3:09 am
I'm guessing that it's because the alias to the first table is missing
sqlString.Append("SELECT m.ID as displayID, isnull(fname,lastname) + " + "' " + "' " + " + lastname as...
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 23, 2008 at 3:04 pm
Maqsood Ahmad (10/23/2008)
DBCC CHECKDB('AlarmSwitch') WITH NO_INFOMSGS
It took about 3 minutes and then I got message 'Command(s) completed successfully.'
Its mean there is no problem with my...
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 23, 2008 at 2:58 pm
victor_bosc (10/23/2008)
The transaction log backup backups the log, but it does not free the space to the operating system. And the shrinkfile release the space.
Correct. However you don't want to...
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 23, 2008 at 2:09 pm
Maqsood Ahmad (10/23/2008)
I understand that in SQL Server 2005 we can't update it but because we have migrated our application from SQL Server 2000 to 2005...
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 23, 2008 at 1:58 pm
Maqsood Ahmad (10/23/2008)
Through some how I want to change system catalog (syscolumns table)In syscolumns table there is a column "colid" I want to change the value of this colid.
Nope....
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 23, 2008 at 1:45 pm
Try the DATEPART and DATENAME functions
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 23, 2008 at 12:34 pm
NULL is not like anything and NULL is not not like anything. A comparison with null (other than IS NULL or IS NOT NULL) will never return true.
http://sqlinthewild.co.za/index.php/2008/01/16/comparisons-with-null/
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 23, 2008 at 12:33 pm
Before you worry about indexing or anything else, I would strongly recommend that you consider normalising that table. You have massive amounts of redundant data and several sets of completely...
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 23, 2008 at 12:30 pm
mohinidba (10/22/2008)
there is any command in sql to shut down the database.shutdown means take offline.only db_owner has that rights.
Why? What are you trying to do?
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 23, 2008 at 10:26 am
watson_mike (10/23/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 23, 2008 at 10:23 am
For that particular query, an index on [order date] INCLUDE [system qty] will help. If you're after more general recommendations, post the table structure, the index definitions and the most...
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 23, 2008 at 10:22 am
Viewing 15 posts - 43,591 through 43,605 (of 49,552 total)