Viewing 15 posts - 331 through 345 (of 1,131 total)
Locking the system tables appears to be an in-appropriate solution but there are some additional activities.
For SQL Server 2000, please see "Concurrency enhancements for the tempdb database" at http://support.microsoft.com/kb/328551....
August 12, 2008 at 11:07 am
Many of the portals (yahoo and google for sure), allow you to save bookmarks on their site if you have an account. These saved bookmarks are accessable from any...
August 12, 2008 at 8:52 am
Forgive if I am new to this but does that mean that inbuilt functions don't add to reported CPU ?
CPU and IO for a UDF are NOT reported by setting...
August 11, 2008 at 9:43 am
Read about the FORMATMESSAGE function in BOL.
Constructs a message from an existing message in sys.messages. The functionality of FORMATMESSAGE resembles that of the RAISERROR statement. However, RAISERROR prints...
August 10, 2008 at 9:07 am
I do not think that you need any triggers as a computed column is a viable alternative solution.
create table dbo.MyTable
(id int not null
,col8 varchar(8) not null
,col9 varchar(8) not null
,col10...
August 10, 2008 at 6:20 am
Regarding "mycol"
What is the datatype ?
What are all the possible values ?
August 9, 2008 at 5:01 pm
Other RDBMS developed the technology before and made it so simple my little sister can do either a "truncate partition table_name:partition_name" or "drop partition table_name:partition_name" in less time that it...
August 8, 2008 at 10:48 am
The job history will have a login name that started the job within the message column
SELECT *
FROM [msdb].[dbo].[sysjobhistory]
where message like '%The Job was invoked by User%'
August 6, 2008 at 3:35 pm
Please read "Forum Etiquette: How to post data/code on a forum to get the best help" at http://www.sqlservercentral.com/articles/Best+Practices/61537/
With the requested data/code, it might be possible to answer your questions. ...
August 6, 2008 at 3:25 pm
Three questions need to be answered before an exact solution can be determined:
1. What datetime column is being used to determine the age? The example uses SellStartDate.
2. ...
August 5, 2008 at 8:41 am
SQL Server hot fixes are accumulative, so if the running version is 8.00.2148 , then you know that hot fixes 2147 , 2145 , 2050 and 2040 have been applied.
There...
August 4, 2008 at 4:19 pm
Regarding using LEFT OUTER JOIN instead of EXCEPT or NOT EXISTS, how do you write such a SQL Statement ? Please use the AdventureWorks demo database to answer the...
August 4, 2008 at 7:58 am
It is interesting that the result of EXCEPT may be different than a NOT EXISTS.
EXCEPT considers NULLS to equal but NOT EXISTS considers NULLS to be unequal. Here is...
August 2, 2008 at 3:20 pm
Ran the provides SQL and the error message is:
Server: Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 67
An INSERT EXEC statement cannot be nested.
So if you have an "insert...
August 1, 2008 at 5:10 am
Thanks steveb
The forum application also remembers that you have set to view that last 10 posts, so it only needs to be set once!
August 1, 2008 at 5:05 am
Viewing 15 posts - 331 through 345 (of 1,131 total)