Viewing 15 posts - 1,786 through 1,800 (of 3,221 total)
Will this help
Declare @date Char(10)
set @date = convert(char(10),'2010-09-02 14:56:09.840',101)
PRINT @date
Using GETDATE()
Declare @date Char(10)
set @date = convert(char(10),GETDATE(),101)
SELECT @date
Result will be 09/02/2010 in either case, or can convert to VARCHAR and...
September 2, 2010 at 12:57 pm
By some strange coincidence as I was reaing this forum, my door bell rang and there was the FedX truck with a package from CDW with my order which was...
September 1, 2010 at 10:01 am
Question .. when executing your stored procedure ... using SSMS ... select ... "Show execution plan". Clear CACHE between executions.
Examine and compae the plans. This will assist you...
September 1, 2010 at 8:12 am
After following the suggestion by PaulB-TheOneAndOnly
First you do it in a test database, once validated you go for production
You can use a CTE something like:
;with numbered as(SELECT rowno=row_number() over
...
August 27, 2010 at 12:24 pm
Here is an example, (Which I copied, more than likely from a posting by Jeff Moden on SSC)
SELECT *
INTO #TestData
FROM (SELECT 'malli','o2o2020' ...
August 23, 2010 at 6:19 pm
espanolanthony
Is the statistic you are attempting to drop the statistic maintained on an Index, that appears to be the problem ?
The DROP STATISTICS command is used to drop statistics,...
August 21, 2010 at 8:52 am
Jayraj.Todkar
Thanks for your compliment ... glad to be of assistance.
August 20, 2010 at 3:32 pm
I took the liberty of attempting to convert your table definition and actual results and post those per instructions contained in the first link in my signature block. That...
August 19, 2010 at 3:39 pm
These links may help you.
http://www.sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx
http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
August 19, 2010 at 2:05 pm
To begin to obtain an understanding of log files may I suggest you read this excellent article by Gail Shaw
http://www.sqlservercentral.com/articles/64582/
Then progress to these:
http://www.sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx
http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
August 19, 2010 at 11:57 am
Using Books On Line - "sys.sql_expression_dependencies (Transact-SQL) "
Here is a sample T-SQL statement that will return the "Referenced Schema Name" and "Referended entity name" (table name)
USE AdventureWorks2008;
GO
SELECT OBJECT_NAME(referencing_id) AS referencing_entity_name,...
August 19, 2010 at 8:39 am
Luke L (8/18/2010)
August 18, 2010 at 6:51 pm
Review the effect of your "SELECT INTO"
From BOL:
Note that your last posting of the T-SQL that works:
The SELECT INTO statement creates a new table and populates it with the result...
August 18, 2010 at 5:19 pm
gspeedtech
To assist you in understanding the problem (Or at least I hope this help)
Execute this command
SET SHOWPLAN_ALL ON
GO
1. Execute your query
2. Examine the execution plan....
August 18, 2010 at 2:24 pm
Viewing 15 posts - 1,786 through 1,800 (of 3,221 total)