quote:Originally posted by satya Have you tried taking a fresh backup and try to restore for test purpose. Backups made on the production server can...
quote:Originally posted by satya Are there any recent changes to the server /operating system/sql server installation? Since when this problem is...
At the moment we have a very worrying situation on our production server. We cannot restore databases. Every time we try to restore a database, SQL...
There seems to be two schools of thought regarding NULLs in databases. 1) NULLs should be used as they were intended, ie to indicate the absence of...
quote:Originally posted by satya Refer to this link http://www.sql-server-performance.com/nb_avoid_bottlenecks.asp] also. This article (and other...
While doing some performance testing with a stored procedure I am working on, I decided to try using a temp table in an effort to speed up part of...
quote:Originally posted by Chappy Dont forget query analyser only shows the first 256 chars of any column by default. You can change this in...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
I am sure this is a simple one, but for some reason my brain isn't working today... I am trying to concatenate several fields in a select statement,...
Thanks guys. I've had a loot at ADO's XML and it seems as if it will almost work for what I am after. We have ADO 2.6 which will let you persist XML...
I am currently looking at using XML in one of the projects I am working on for my current client. My client uses SQL Server 7.0 and has no immediate...
UPDATE MyTableName SET MyColumnName = REPLACE(CAST(MyColumnName as varchar(5000)), '<br>,'') WHERE LEN(MyColumnName) <= 5000
You will need to write a stored procedure to do this. Something along the lines of (this is off the top of my head, may not be 100% - don't have...
Brad, I agree that the official explanation of table spools is very confusing and far from clear. The picture in my mind however is that SQL is...
What techniques can be used to re-write queries so that they do not use table spools? All the material I see mentioning query optimisation says that...
Okay, I've been working all day, jumping from SQL code to ASP code to analysing various server perfomance data to troubleshooting IIS problems. My...
quote:Originally posted by mjaganmr I am populationg a target table with 24K rows. It's taking 19 min to complete the process using row by row...
quote:Originally posted by Jeff Smith I was always taught that the column list in a SQL statement had no bearing on the performance. I recently...
quote:Originally posted by trifunk I'm not to sure on this but it might be an alternative. Given that you've split the words up would it not be...
Separate names with a comma.
