Viewing 15 posts - 181 through 195 (of 1,131 total)
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
June 17, 2009 at 4:15 am
For your error "write failure on backup device 'D:\admin\backup\bx01t_db.DAT' ... The system cannot find the file specified"
If you open a command prompt on the server and run:
DIR D:\admin\backup\bx01t_db.DAT
Is the file...
SQL = Scarcely Qualifies as a Language
June 16, 2009 at 2:40 pm
Viewing 15 posts - 181 through 195 (of 1,131 total)