Welsh Corgi

Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 3,738 total)

RE: WITH DROP_EXISTING = ON Fails before I create the INDEX on SQL Server Instance

Lynn Pettis (7/22/2012)
Realizing I have an unnecessary join, this would also work:
if exists(select 1
from sys.indexes i
...
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/

July 22, 2012 at 4:26 pm

#1516027
RE: WITH DROP_EXISTING = ON Fails before I create the INDEX on SQL Server Instance

Yes, but I'm trying to create the Index without error regardless of whether the Index Exists or not.
So correct me but I don't believe that you directly answered my question?
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/

July 22, 2012 at 3:57 pm

#1516022
RE: WITH DROP_EXISTING = ON Fails before I create the INDEX on SQL Server Instance

I determined that if the Index does not exist you will get the error no matter what.
You have to first create the Index and then execute with that option.
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/

July 22, 2012 at 3:09 pm

#1516015
RE: WITH DROP_EXISTING = ON Fails before I create the INDEX on SQL Server Instance

lokeshvij (7/22/2012)
I tried this on my PC. Same result.
Seems to be a limitation of DROP_EXISTING :unsure:
Did it work on not?
I get different results and it appears to be machine dependent.
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/

July 22, 2012 at 11:14 am

#1515996
RE: Staging Incremental Methodology - Flag Record as an INSERT, UPDATE or DELETE to the Data Warehouse Table

Whan I said flag them as inactive I dod not mean to store an "Inactive Flag", I mean to indicate that they were inactive as a particular Date, etc.
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/

July 21, 2012 at 3:59 pm

#1515895
RE: Staging Incremental Methodology - Flag Record as an INSERT, UPDATE or DELETE to the Data Warehouse Table

Thanks for the responses.
I totally agree and understand that you do not want to delete records but flag them as inactive.
As far as the OUTPUT Clause could you please go...
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/

July 21, 2012 at 2:38 pm

#1515883
RE: Staging Incremental Methodology - Flag Record as an INSERT, UPDATE or DELETE to the Data Warehouse Table

richykong (7/20/2012)
Depends on your ETL process to load from staging to target, but you should be able to capture INSERT/UPDATE/DELETE records from the ETL process. I used the MERGE...
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/

July 20, 2012 at 1:52 pm

#1515739
RE: Need Script to List Foreign Keys for a Table - Error TRUNCATING Table

Sean,
That is a very straight forward script.
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/

July 20, 2012 at 1:48 pm

#1515736
RE: Database In Recovery

It recovered.
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/

July 20, 2012 at 1:06 pm

#1515716
RE: What is the best way to encrypt SSNs and FEIN Numbers (Employer Tax ID Number) in SQL Server 2008?

GilaMonster (7/17/2012)
Expert SQL Server 2005 Development. Not the 2008 one, the 2005 one.
Oh shucks my Student free delivery for FedEx & UPS (United Parcel Service) for two day delivery just...
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/

July 17, 2012 at 1:28 pm

#1513839
RE: What is the best way to encrypt SSNs and FEIN Numbers (Employer Tax ID Number) in SQL Server 2008?

I'm looking for a very simple example on Data hashing in SQL Server.
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/

July 17, 2012 at 11:26 am

#1513752
RE: What is the best way to encrypt SSNs and FEIN Numbers (Employer Tax ID Number) in SQL Server 2008?

Does someone know of a good white paper on the hash option to encryption?
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/

July 17, 2012 at 7:18 am

#1513573
RE: Maximum Memory Windows Server 2003 32 bit?

I typed 32 GB of memory, it is 4 GB of memory on a 32 bit OS.:w00t:
Thanks for all of the information.
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/

July 17, 2012 at 6:57 am

#1513568
RE: Maximum Memory Windows Server 2003 32 bit?

I could do an in Place Upgrade to the OS to Enterprise Edition.
Has anyone tried that and what was the outcome>
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/

July 17, 2012 at 6:27 am

#1513548
RE: Import fails using SQL Server Import and Export Wizard

You are getting an error on the ModifiedDate.
A Record(s) in the Source Column for ModifiedDate is too large.
What is the largest value for that column in your flat file.
Have 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/

July 16, 2012 at 5:33 am

#1513006

Viewing 15 posts - 1,261 through 1,275 (of 3,738 total)