WayneS

Forum Replies Created

Viewing 15 posts - 3,466 through 3,480 (of 5,588 total)

RE: Can splitting a database to several databses improve performance.

coolwebs (8/31/2010)
Three databases running on the same physical hard drive will perform no better than a single database on that same physical hard drive.
Well, the three databases will be in...
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

August 31, 2010 at 11:29 am

#1214504
RE: Table Variable vs. Temp Table - errors?

I appreciate your trying to get something that will duplicate the issue. However, as you've mentioned, it isn't making sense why the table variable won't work with the temp table...
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

August 31, 2010 at 11:25 am

#1214497
RE: Need a count by date including dates with a zero count

Mark did a good job.
If you also need dates to show if there were zero tickets for all reps for that date, then you need to utilize a calendar table....
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

August 31, 2010 at 11:20 am

#1214494
RE: Loop through multiple excel files

I think that you also have to deal with the spreadsheet tab names - if they are unknown, SSIS won't be able to open up your spreadsheet.
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

August 31, 2010 at 10:39 am

#1214471
RE: Transactions in sql

skcadavre,
This isn't really a good example, since table variables don't participate in transactions to begin with.
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

August 31, 2010 at 9:37 am

#1214424
RE: Are the posted questions getting worse?

GilaMonster (8/31/2010)
WayneS (8/31/2010)
GilaMonster (8/31/2010)
I tend to use the term 'Database Specialist', as I do everything around DBs, architecture, admin, dev, BI, optimisation, DR, etc.
Over here in the US, we tend...
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

August 31, 2010 at 9:20 am

#1214402
RE: Clustering

Good to know that George.
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

August 31, 2010 at 9:11 am

#1214390
RE: Advantages of Cursors

Any looping code can have an "infinite looping error". After all, that is just bad programming.
The real solution is to remove all loop processing, and to convert it to set-based...
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

August 31, 2010 at 9:08 am

#1214387
RE: Clustering

subha.msc2007 (8/31/2010)
thanks for your solution..
&
what is diff between active/active VS active/possive clustering.
Subha
Active/Active - there is at least one SQL instance running on each of two nodes.
Active/Passive - there is...
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

August 31, 2010 at 8:51 am

#1214370
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/31/2010)
Paul White NZ (8/31/2010)
Good job on the scheduling, Steve. Very neat.
Thanks.
Look for Mr. White's optimizer series over the next few weeks.
AWESOME!
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

August 31, 2010 at 8:26 am

#1214345
RE: Are the posted questions getting worse?

GilaMonster (8/31/2010)
I tend to use the term 'Database Specialist', as I do everything around DBs, architecture, admin, dev, BI, optimisation, DR, etc.
Over here in the US, we tend to call...
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

August 31, 2010 at 8:24 am

#1214343
RE: Select Columns based on input

Steve,
Thanks for the feedback. Sounds like you came up with a do-able solution.
(Isn't it amazing how many people run into the "can't see the forest for the trees" type of...
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

August 31, 2010 at 8:09 am

#1214322
RE: Transactions in sql

Have you tested this? What did you find out?
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

August 31, 2010 at 8:03 am

#1214316
RE: Advantages of Cursors

suraj.app (8/31/2010)
Hi,
What is advantage of cursors. What ever we can do with cursors can also be done using while loops, temp tables.
So, what is the advantage of using cursors...
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

August 31, 2010 at 8:01 am

#1214314
RE: did you leave a secure job, what pushed you to move and how did you get on?

winston Smith (8/31/2010)
I know i can study these areas outside of work, and i have done, but im one of these "use it or lose it" people. if im not...
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

August 31, 2010 at 7:56 am

#1214309

Viewing 15 posts - 3,466 through 3,480 (of 5,588 total)