WayneS

Forum Replies Created

Viewing 15 posts - 3,331 through 3,345 (of 5,588 total)

RE: This query runs slower than expected

No where clause.
No index on the columns being joined.
No index on the columns in the where clause (just in case you didn't specify it in your post).
Using functions on columns...
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

September 6, 2010 at 1:47 pm

#1217035
RE: Please don’t Tweet this, but…

niall.baird (9/5/2010)
Being possibly the only person in the universe that doesn't have a twitter account, a facebook page, a myspace page or anything else like that (other than a linkedin...
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

September 6, 2010 at 1:44 pm

#1217034
RE: how to replace data from another database?

mak101 (9/6/2010)
I used import wizard in SSMS to import data and stored as package. Can I open the package in SSMS?
As Jeffrey already said:
Jeffrey Williams-493691 (9/6/2010)
mak101 (9/6/2010)
How can I 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

September 6, 2010 at 1:08 pm

#1217031
RE: Selecting only oldest date in a 2 table join

Johnnymac (9/6/2010)
awesome, thanks wayne, that did the trick. I was able to add a few more columns I wanted to show in the report, its prompting for the start...
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

September 6, 2010 at 1:03 pm

#1217030
RE: how to replace data from another database?

mak101 (9/6/2010)
And I saved it as SSIS package on the server. But I don't find the way to open it. Can you please help?
Thanks.
Open up BIDS. Start a new SSIS...
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

September 6, 2010 at 11:34 am

#1217013
RE: how to replace data from another database?

mak101 (9/6/2010)
Thank you found it.
Another question- How do I keep same identity value from original table?
On that same screen (Column Mappings) is a check box for "Enable Identity Insert"....
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

September 6, 2010 at 11:30 am

#1217011
RE: Do I need a private heartbeat network?

Also, if you have a two-node cluster with the nodes really close together, you can use a network cross-over cable.
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

September 6, 2010 at 11:24 am

#1217009
RE: Do I need a private heartbeat network?

Everything that I've read about clustering says that the private heartbeat should be on it's own network gear, separate subnet, etc. Essentially, try to keep it off of the main...
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

September 6, 2010 at 11:23 am

#1217006
RE: how to replace data from another database?

On the Import Wizard, when you get to the screen where you select the Source Tables and Views, select the tables you want to copy FROM. Then, click the "Edit...
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

September 6, 2010 at 10:16 am

#1216984
RE: Are the posted questions getting worse?

GilaMonster (9/6/2010)
CirquedeSQLeil (9/6/2010)
Happy Labor Day all.
Labour day is a good description for today - first day back from a week-long 'holiday'
If your "holiday" is anything like mine, then 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

September 6, 2010 at 10:07 am

#1216977
RE: What is the use of SQL Injection?

Good point Perry.
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

September 6, 2010 at 8:54 am

#1216959
RE: Selecting only oldest date in a 2 table join

Without having the table ddl, I'm guessing here, but this looks like it would work:
SELECT account0.name as 'name',
ab.createdon as 'orderdate'
FROM FilteredAccount...
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

September 5, 2010 at 8:25 pm

#1216745
RE: What is the use of SQL Injection?

Lynn Pettis (9/5/2010)
Jeff Moden (9/5/2010)
Sooooo... now that we've taught someone how to accomplish SQL Injection, I have to ask... will he use it to avoid injection or carry out revenge...
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

September 5, 2010 at 8:17 pm

#1216744
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

David,
I was looking at your code you posted, and I have a couple of suggestions for you.
First, create the function as an in-line table-valued function (TVF). Not only is much...
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

September 5, 2010 at 8:11 pm

#1216743
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Jeff Moden (9/3/2010)
WayneS has a link to your Cross Tabs and Pivots article on his signature line(thank you WayneS 🙂
Thank you for the reference and for helping others, as...
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

September 5, 2010 at 8:00 pm

#1216740

Viewing 15 posts - 3,331 through 3,345 (of 5,588 total)