Viewing 15 posts - 1,741 through 1,755 (of 3,221 total)
Results for SQL 2008 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP - code run was that after you edited...
September 19, 2010 at 10:02 am
Results for SQL 2005 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP
Now do you need one run on SQL...
September 18, 2010 at 9:12 pm
Results for SQL 2008 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP
Between this and my prior post should...
September 18, 2010 at 6:46 pm
Jeff ran test on the oldest, least amount of memory, slowest desktop, age - older than dirt. Running Windows XP
Result for SQL 2005 Express in attached word doc.
Will...
September 18, 2010 at 6:41 pm
Are you familiar with the SP (In master DB) sp_FOREACHDB? To read how to use this go to:
September 18, 2010 at 11:23 am
abcim
When posting a performance problem, to assist you in obtaining the best answer, please click on the second link in my signature block, and attempt to follow its instruction...
September 18, 2010 at 10:03 am
I would suggest reading the following
http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/
AND the comments on the article describing some different approaches.
September 17, 2010 at 8:41 pm
I had to test this code in 2005, but it should perform identically in 2008
Your data with a few entries added
CREATE TABLE #T(Addrid INT, Addr VARCHAR(15), datex DATETIME)
INSERT INTO...
September 17, 2010 at 7:23 pm
From a SQL 2000 Server.
The following assumes you are using EXCEL 2003 or earlier. If you are using EXCEL 2007 or later then the command must be altered to...
September 17, 2010 at 6:12 pm
SKYBVI (9/17/2010)
oopssorry for posting twice
i couldnt find the delete post option
is it there?
Regards,
Sushant
Go back to the post in question.
Click on the "Edit" button
It will open in a window similar to...
September 17, 2010 at 3:08 pm
GilaMonster (9/17/2010)
jcrawf02 (9/17/2010)
Chris Morris-439714 (9/17/2010)
Oh heck - fresh crab, lapping waves. What a thought. It's gonna be a long day.
Haven't been able to eat crab since we went to Alaska...
September 17, 2010 at 7:34 am
Is this what you are looking for?
SELECT DAY =
CASE STR(DAY(GETDATE()))
WHEN...
September 16, 2010 at 7:49 pm
I do not understand why you wish to do this to values in a table and not in the T-SQL statement which selects the data from the table, but you...
September 16, 2010 at 7:30 pm
Please, please the next time you post include the table definition, sample input data in a format easy to use. To learn how to do this quickly and easily...
September 16, 2010 at 7:09 pm
Wayne this is a follow on for the posting in SQL 2000 Forum:
Table definition:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GPM_Safety_Inspection]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GPM_Safety_Inspection]
GO
/******...
September 16, 2010 at 4:57 pm
Viewing 15 posts - 1,741 through 1,755 (of 3,221 total)