Viewing 15 posts - 47,401 through 47,415 (of 49,552 total)
Please don't cross post. It wastes people's time and fragments replies. I answered your other post.
Replies to the following thread please - How to do Coalesce
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
February 12, 2008 at 12:56 am
I'm not sure what you're trying to do with Coalesce. Coalesce just returns the first non-null expression from the arguments passed to it. So
Coalesce('1,2',idcol) will return '1,2' always, since it's...
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
February 12, 2008 at 12:48 am
My database seems to be somehow encrypted by the software I used
What software are you using?
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
February 11, 2008 at 11:35 pm
Nisha (2/11/2008)
Gail, do you mean the syntax is incorrect in SS 2k5?
It's ambiguous. It isn't clear what you mean. Try this one
SELECT DISTINCT FirstName as Name, LastName as Name
FROM Person.Contact
ORDER...
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
February 11, 2008 at 11:24 pm
Thanks for been honest about it being homework.
Show us what you've done so far and what problems you are having and someone will help.
We don't do homework assignments for...
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
February 11, 2008 at 11:22 pm
If the server you're connecting to is SQL 2000 or the adventureworks DB you're using is in compatability mode 80, the query will work fine.
Against a SQL 2005 server with...
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
February 11, 2008 at 3:40 am
What do you mean by 'producion support level'?
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
February 11, 2008 at 2:36 am
It's possible that this will be allowed in SQL 2008, as one of the changes in 2008 is to allow passing of table variables to stored procedures.
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
February 11, 2008 at 2:36 am
Check the sys.dm_exec_requests DMV. What are the long running queries waiting on?
Have you rebuilt indexes recently?
Does recompiling the procedure make any difference? (EXEC sp_recompile 'StoredProcName')
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
February 10, 2008 at 5:42 am
Whe SQL deletes a row, it doesn't overwrite the entry on the data page, it just marks the space as available (pretty much same thing as on a file system...
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
February 10, 2008 at 5:36 am
Shrinking databases is generally a bad idea. A database needs some space in it for normal operation.
How long is a question that's very hard to answer. It depends on 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
February 10, 2008 at 5:31 am
Federico Zajur (2/8/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
February 8, 2008 at 6:15 am
Not directly, though you could convert the month number inot a date.
SELECT DATENAME(month,'1900/' + CAST(monthNumber AS VARCHAR(2)) + '/01')
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
February 8, 2008 at 1:52 am
SQL has a DateName function, however it takes a datetime as a parameter, not a number
SELECT DATENAME(month, GETDATE()) AS 'Month Name'
returns
Month Name ...
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
February 8, 2008 at 1:30 am
in SQL 2000, I believe that rebuilding the clustred index rebuilds the nonclustered indxes. In SQL 2005, that's no longer the case.
You can just use DBCC DBReindex to rebuild all...
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
February 8, 2008 at 12:04 am
Viewing 15 posts - 47,401 through 47,415 (of 49,552 total)