Viewing 15 posts - 49,291 through 49,305 (of 49,552 total)
REPLACE(@str,'''','''''')
Works in SQL 2000, can't say about 7.
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
November 25, 2005 at 5:38 am
BoL also says the following:
Indexes can be created on either a single column or a combination of columns in a table and are implemented in the form of B-trees. An...
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
November 25, 2005 at 4:04 am
One minor comment on your superfluous indexes...
If you have an index on a,b,c then a second index on a is indeed a waste of space and time. The index on c...
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
November 25, 2005 at 12:44 am
You don't like developers do you? Personally the idea of chastisng a developer because they don't agree with you strikes me as arrogance that really doesn't belong in an IT...
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
November 24, 2005 at 11:42 pm
Table-valued functions may also be used in the from clause
SELECT blah FROM dbo.SomeFunction(@Param1, @Param2)
In addition to the restrictions already listed, functions cannot have any side effect. Hence you cannot insert...
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
November 24, 2005 at 3:40 am
Thanks, interesting reading (the entire article)
I'm tending to suspect there's a problem with the disk system (though the SAN people disagree, naturally). The server's not short on memory, got 48GB...
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
November 23, 2005 at 6:45 am
Converting that many records shouldn't fill TempDB.
Try a restart of SQL (assuming that this is not a production system and you can restart SQL without impacting users) as 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
November 23, 2005 at 2:23 am
What error do you get? It might be because there are non-numeric values in the column.
Try this
SELECT SUM(CAST(col AS FLOAT)) FROM tbl WHERE ISNUMERIC(col)=1
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
November 23, 2005 at 1:12 am
Looks like your problem is lack of available hard drive space.
You said you had 16GB free of 19GB on drive C, but the tempdb is on drive C 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
November 22, 2005 at 4:16 am
In the interests of keeping all relevent info in one thread, see
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=238067
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
November 22, 2005 at 3:23 am
I can't see pictures that are on your hard drive. Please post the results of sp_helptext in text.
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
November 22, 2005 at 3:21 am
Please don't cross-post. Replies to the following thread
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=238067
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
November 22, 2005 at 2:56 am
OK, so it's not HDD space.
Please run sp_helpdb 'TempDB' and post the output
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
November 22, 2005 at 12:56 am
It looks like either the disk that TempDB is on is full, or the TempDB database is set with fixed size and has filled up.
Check the disk, check the properties...
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
November 22, 2005 at 12:00 am
As an aside. Consider moving the insert into a stored procedure and calling the stored procedure from your app. It's more efficient and more secure.
As written, your code is potentialy...
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
November 21, 2005 at 4:48 am
Viewing 15 posts - 49,291 through 49,305 (of 49,552 total)