Viewing 15 posts - 181 through 195 (of 1,132 total)
This type of requirement is becoming more frequent with virtualization and consolidation and is easy to solve.
Assume you have
1) TestServer at IP 192.168.2.2
2) TestServer hosts SQL Servers TestServer\Test1,...
June 18, 2009 at 10:34 am
Well, you could add a new status meaning "product excluded for other reasons" and only then allow free form characters.
Assume ProductStatus = 999 means that a text is needed, which...
June 18, 2009 at 10:10 am
change the SQL 2005 Services logon account from LocalSystem to a windows service account which is part of local admin group. User will enter the userid and password in a...
June 18, 2009 at 9:29 am
The problems with the money datatype has been know for decades (I knew about in 1993 from working with Sybase) and the problems have been posted by SQL Server MVPs...
June 18, 2009 at 8:36 am
Piotr is quite correct that the function is executed for each row and the start-up and shutdown cost of each function execution is very expensive including such processing as...
June 17, 2009 at 7:22 pm
OOPS - For the EXCEPT, missed a condition in the ON, so please add:
and GroupLatest.DateEntered = Groups.DateEntered
Table 'Groups'. Scan count 3, logical reads 5851
Table 'Worktable'. Scan count 1, logical reads...
June 17, 2009 at 4:24 pm
Actually, GSquared proposed the CTE solution but I was interested in comparing the performance to the "legacy" exists solution, which is needed when the RDBMS does not support window...
June 17, 2009 at 4:20 pm
"Can a Parent be joined to a Child table on a field that has not been defined as a Foreign Key?"
Yes , you can define any join criteria...
June 17, 2009 at 3:49 pm
I have encountered a few cases where a tempdb clean-up is needed especially when connection pooling is used, resulting in a connection being open for weeks. Please read "Working...
June 17, 2009 at 3:30 pm
The requirement is "the most recently entered group should have the special code and that all others should be blank."
GSquared's solution needs a minor correction to partition by GroupName...
June 17, 2009 at 12:15 pm
Jeff, you are correct that nowhere does MS state that restarting SQL Server is the "best practice" to reduce the size of tempdb. But since the two non-restart method...
June 17, 2009 at 10:52 am
Please be aware that results of the calculation using the MONEY datatype are often incorrect, especially when dividing. Suggest you use NUMERIC with the appropriate scale.
Here is an example of...
June 17, 2009 at 7:53 am
Take a look at the client's ODBC version as you may have encountered this bug:
"SQL Server ODBC Driver Ignores Authentication Setting" http://support.microsoft.com/kb/279526
When you use the SQL Server ODBC driver...
June 17, 2009 at 6:57 am
MS does recommend a SQL Server restart as documented at "How to shrink the tempdb database in SQL Server" http://support.microsoft.com/kb/307487
There is also this note:
If tempdb is in use and...
June 17, 2009 at 6:40 am
Originally, the "Timestamp" datatype was defined as a counter of database row updates. Later, the ISO defined the "Timestamp" datatype as date and time information, causing a conflict between...
June 17, 2009 at 4:15 am
Viewing 15 posts - 181 through 195 (of 1,132 total)