WayneS

Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 5,588 total)

RE: Faster way to do Top N Order By Desc?

Donalith (10/13/2010)
Is there a faster way to get the Top 1000 rows sorted on
ORDER BY COALESCE(<possible null field>,1) DESC
The plan shows that this sort is taking up 86% of my...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 9:23 am

#1236945
RE: Script to insert all columns' name into a table

Looks like you're making things more difficult than necessary Lowell! ;-):w00t:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 9:19 am

#1236942
RE: Flat File Import in SQL Server 2005

pt9s (10/13/2010)
Wayne
This is great!
Thanks so much!!!
You're welcome.
Does it solve your issue?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 9:17 am

#1236938
RE: How to find no of employees getting weekOff in the same day for across last 4,3,2 weeks

Did you try the things suggestion on this other post you made on this same issue?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 9:15 am

#1236934
RE: How to find no of employees getting weekOff in the same day for across last 4,3,2 weeks

Did you try running this code?
CREATE TABLE Test1(
empno int,
MatchingOff varchar(10),
atnDate datetime
)
SET IDENTITY_INSERT mytable ON
Insert into TestTable(empno,MatchingOff,atnDate)
There are 3 different tables referenced here... and it looks like the IDENTITY INSERT isn't...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 9:12 am

#1236931
RE: SSIS Excel File Loading Error

I've never seen that happen.
If you can get desktop access to the computer that houses the Excel file, you can see who/what has the file open.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 9:05 am

#1236919
RE: report PDf generation

Sure, why wouldn't it? You might need to change your stored procedure/query around a bit to work with multiple values, but it wouldn't be a big deal.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 9:03 am

#1236915
RE: Downtime

scott_lotus (10/14/2010)
Mirroring the db doesnt help me ether as i cannot afford to mirror the a/p cluster ( i think this is how it has to be done ? )
I...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 7:17 am

#1236828
RE: SSIS Excel File Loading Error

CozyRoc (10/13/2010)
This is the important part:
"The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 7:07 am

#1236820
RE: Learning Oracle

If you look at these two posts, especially the signature, and that these are the only posts ever from this poster, they feel more like spam for their kitchen cabinets.
harrifolfenced...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 6:45 am

#1236793
RE: DBCC issue

GilaMonster (10/14/2010)
WayneS (10/13/2010)
If so, you might want to check out these links (NOTE: the methods described are NOT supported by Microsoft!!!):
TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 14, 2010 at 5:00 am

#1236727
RE: DBCC issue

Have you recently upgraded these databases from SQL 2000?
If so, you might want to check out these links (NOTE: the methods described are NOT supported by Microsoft!!!):
TechEd Demo: Using the...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 13, 2010 at 10:52 pm

#1236622
RE: backup restore full recovery model sql 2005

The frequency of the transaction log should be dependent on your service agreement... how much data can you afford to lose, or have to re-enter? On our systems, we have...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 13, 2010 at 10:45 pm

#1236621
RE: Sql report - inactive suppliers

You also don't have any sales for acct's 5/6 in June.
How does this work for you?
SELECT c.ACCT_NO, c.L_NAME, sum(IsNull(p.SALE_PRICE,0))
FROM Creditor c
LEFT...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 13, 2010 at 10:40 pm

#1236619
RE: Geographically dispersed multi-site "multi-instance" with SQL 2008 R2

Clustering <> load balancing. A SQL Instance installed on a cluster can only be active on ONE node of the cluster at a time. This geographically disbursed cluster is designed...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

October 13, 2010 at 9:23 pm

#1236609

Viewing 15 posts - 2,866 through 2,880 (of 5,588 total)