Welsh Corgi

Forum Replies Created

Viewing 15 posts - 946 through 960 (of 3,738 total)

RE: Database in Restoring State since upgrade of OS to Windows Server 2008 Enterprise

Lynn Pettis (1/17/2014)
Restoring or Recovery? Just want to be sure.
Can you provide more information regarding the database? Is it the target of log shipping or mirroring?
It went into...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 17, 2014 at 4:10 pm

#1681300
RE: Deprecated]Function call can be extracted from the WHERE clause to avoid unnecessary table scan.

I removed the function from the WHERE and replaced it with a local variable:
AND CD_DW_INSERT_DATE > @Date

I got another problem on a JOIN.
Found filtering columns wrapped inside User-Defined Function...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 16, 2014 at 12:51 pm

#1680830
RE: Avoid ISNumeric and dealing with Nullable Columns

Thanks Kraig.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 16, 2014 at 11:07 am

#1680783
RE: Deprecated]Function call can be extracted from the WHERE clause to avoid unnecessary table scan.

Lowell (1/16/2014)
dateadd is not deprecated.
I run it through ubitsoft's T-SQL Analyzer and I get the following:
SA0028 : [Deprecated]Function call can be extracted from the WHERE clause to avoid...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 16, 2014 at 10:31 am

#1680764
RE: Avoid ISNumeric and dealing with Nullable Columns

I get the following warning when using SQL Enlight:
Avoid using ISNUMERIC function as it accepts floating point and monetary number.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 16, 2014 at 10:19 am

#1680755
RE: Generate Scripts

David McKinney (1/15/2014)
I may be missing your point, but when I go into Tools / Options / SQL Server Object Explorer / Scripting, I can set script indexes to true....
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 15, 2014 at 8:27 am

#1680298
RE: Flat File Source and Flat File Destination & Convert Dates to text mm/dd/yyyy

Thanks for the replies.
The following worked:
SUBSTRING(Inception,6,2) + "/" + SUBSTRING(Inception,9,2) + "/" + SUBSTRING(Inception,1,4)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 10, 2014 at 9:44 am

#1679233
RE: Flat File Source and Flat File Destination & Convert Dates to text mm/dd/yyyy

I tried using the following expression and it is not valid syntax. Can not parse.
I had to change the Column from Inception which I defined to Column 8 as well.
(DT_WSTR,...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 10, 2014 at 7:57 am

#1679178
RE: Flat File Source and Flat File Destination & Convert Dates to text mm/dd/yyyy

I hope that this is enough information.
Source:
6600154038120140301REN|XO|XO||FL|81|660015403|2010-03-01 00:00:00|03/01/2014|12|
Destination Desired Output:
6600154038120140301REN|XO|XO||FL|81|660015403|03/01/2010|03/01/2014|
Thank you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 10, 2014 at 6:09 am

#1679123
RE: Flat File Source and Flat File Destination & Convert Dates to text mm/dd/yyyy

:crazy:
Koen Verbeeck (1/9/2014)
You read the file with SSIS, do the transformations with a derived column and write the data back to a file.
I was thinking that it might have been...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 9, 2014 at 3:43 pm

#1679006
RE: Convert SQL Server Date to DD/MM/YY

Thanks Lynn. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 9, 2014 at 9:33 am

#1678846
RE: Convert SQL Server Date to DD/MM/YY

Luis Cazares (1/9/2014)
Oh my, so much code! My laziness wants to write less.
declare @SSDate datetime = '20140109'
declare @CharSSDate char(10)
SELECT CONVERT( char(10), @SSDate, 103), --4-digit year
STUFF( CONVERT( char(10), @SSDate, 103),...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 9, 2014 at 9:32 am

#1678844
RE: Convert SQL Server Date to DD/MM/YY

Kurt W. Zimmerman (1/9/2014)
Your first post indicated you wanted a 2 digit year. Your solution provides you a 4 digit year. Just saying.
Kurt
Sorry about the Year.
It first was...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 9, 2014 at 9:29 am

#1678843
RE: Convert SQL Server Date to DD/MM/YY

I got it.
,RIGHT('0' + CAST(DATEPART(mm,PURCHASE_DATE) as varchar(2)),2)+ '/' +
RIGHT('0' + CAST(DATEPART(dd,PURCHASE_DATE) as varchar(2)),2)+ '/' +
CAST(DATEPART(yyyy,PURCHASE_DATE) as varchar(4))...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

January 9, 2014 at 8:20 am

#1678795
RE: Rebuild Index Maintenance Plan with Default Amount of free space

The tables are small.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 4, 2013 at 6:54 am

#1670702

Viewing 15 posts - 946 through 960 (of 3,738 total)