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....
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
August 10, 2008 at 6:20 am
Regarding "mycol"
What is the datatype ?
What are all the possible values ?
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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%'
SQL = Scarcely Qualifies as a Language
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. ...
SQL = Scarcely Qualifies as a Language
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. ...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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...
SQL = Scarcely Qualifies as a Language
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!
SQL = Scarcely Qualifies as a Language
August 1, 2008 at 5:05 am
Viewing 15 posts - 331 through 345 (of 1,131 total)