Viewing 15 posts - 49,306 through 49,320 (of 49,566 total)
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...
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...
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...
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...
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...
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...
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
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...
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
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.
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
November 22, 2005 at 2:56 am
OK, so it's not HDD space.
Please run sp_helpdb 'TempDB' and post the output
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...
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...
November 21, 2005 at 4:48 am
Sure. You can have as many ouput parameters as you want.
CREATE PROCEDURE Test
@Out1 int OUTPUT,
@Out2 char(1) OUTPUT
AS
SELECT @Out1=1, @Out2='Y'
GO
DECLARE @Var1 int, @Var2 char(1)
EXEC Test @Var1 OUTPUT, @Var2 OUTPUT
SELECT @Var1, @Var2
--
I...
November 21, 2005 at 4:31 am
Viewing 15 posts - 49,306 through 49,320 (of 49,566 total)