Viewing 15 posts - 47,956 through 47,970 (of 49,552 total)
Scott H. Chang (12/21/2007)
Hi all,IF EXISTS (SELECT PivotedLabTests FROM sys.tables
WHERE PivotedLabTests = 'pvt')
DROP TABLE pvt
Firstly, this....
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
December 21, 2007 at 2:20 pm
Please don't create multiple threads on the same problem. It just fragments replies and annoys the regulars.
Since this is a continuation of your old thread, please continue it there
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
December 21, 2007 at 1:32 pm
Since you're using SQL 2005, you can use the Row_number function. makes this kinda thing very easy.
Since I also suspect homework 😉 at least until told otherwise, consider this
ROW_NUMBER() OVER...
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
December 21, 2007 at 1:26 pm
Autoclose means that when the last connection is dropped from a DB, the DB is shut down cleanly, just as if the server had shut down. While the DB is...
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
December 21, 2007 at 1:21 pm
Hint
DECLARE @Var1 INT
SET @Var1 = NULL
SELECT
CASE WHEN @Var1 = NULL THEN 'Var1 = Null' ELSE 'Var1 <> NULL' END AS EqualityTest,
CASE WHEN @Var1 <> NULL THEN 'Var1...
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
December 21, 2007 at 1:15 pm
colin Leversuch-Roberts (12/21/2007)
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
December 21, 2007 at 1:00 pm
Oh you certainly did. Almost to the coffee over keyboard point. Especially the bat.
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
December 21, 2007 at 12:56 pm
misandrew (12/21/2007)
only valide for Master database
for the other USER database
it produce error !!
What error?
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
December 21, 2007 at 12:51 pm
Shut down the server (if its running) and move the tempdb files back to where they were (and any other files that you moved) then restart SQL. It should come...
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
December 21, 2007 at 12:48 pm
Do you have any indexes other than the one you posted? Especially, do you have a clustered index?
If you don't have a cluster, I would suggest a clustered index on...
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
December 21, 2007 at 12:42 pm
The DB restore would have been the cause of the cache flush that you saw in the error log. In this case it's nothing to be concerned with. It's just...
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
December 21, 2007 at 12:33 pm
What was the problem?
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
December 21, 2007 at 6:00 am
colin Leversuch-Roberts (12/21/2007)
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
December 21, 2007 at 5:14 am
Ok.
As I said, I know very little about notification services. Is there any way to check which query notifications are active in the DB?
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
December 21, 2007 at 4:51 am
Adam Haines (12/20/2007)
You are absolutely correct. I forgot to mention that "column2" has to be an actual column in the table for this work. You cannot do this...
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
December 21, 2007 at 12:17 am
Viewing 15 posts - 47,956 through 47,970 (of 49,552 total)