WayneS

Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 5,588 total)

RE: Registering 300+ SQL Servers to management studio from a list

If you're using SSMS 2008, there is another neat trick. In the Registered Servers panel, make separate folders for each logical (to you) group. Then, you can right-click the group,...
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

November 30, 2010 at 6:11 am

#1256731
RE: badly need help

InfiniteError (11/29/2010)
The most likely effect of directly modifying the system tables is to... cause corruption. 😀
i just need to modify the date modified column, that's all, and nothing else if...
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

November 29, 2010 at 7:48 pm

#1256570
RE: badly need help

InfiniteError (11/29/2010)
i tried that, but unfortunately it did not work... is there any other way..?
Actually, altering the procedure does not change the create date... you have to drop the procedure,...
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

November 29, 2010 at 7:44 pm

#1256569
RE: ONE-TIME MIGRATION FROM ORACLE TO SQL SERVER.

xpxj (11/29/2010)
167 pgs of instruction for . . .
"The free Microsoft SQL Server Migration Assistant (SSMA) for Oracle speeds the migration process. SSMA for Oracle V4.0 converts Oracle database objects...
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

November 29, 2010 at 7:07 pm

#1256566
RE: badly need help

Lowell (11/29/2010)
InfiniteError (11/29/2010)
thanks for the reply
Im sorry i use the sql 2005 keyword, the changes that i want to made is in sql server 2000, i google it and many...
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

November 29, 2010 at 7:02 pm

#1256564
RE: Table valued function

I think the best thing to do would be to generate the csv file through either the OpenRowset function, or via BCP. Then email that file.
By running the query 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

November 29, 2010 at 6:16 pm

#1256557
RE: Ready for Inspection

Steve Jones - SSC Editor (11/29/2010)
Your job ought to be well documented, ready for inspection, or more likely, ready for someone else in case you get hit by the proverbial...
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

November 29, 2010 at 3:26 pm

#1256529
RE: Need help building a query.

GSquared (11/29/2010)
Wayne, just because a table has an ordered clustered index, doesn't mean an identity column will honor that order. Usually it will, but you can't guarantee it.
Jeff's solution...
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

November 29, 2010 at 3:13 pm

#1256523
RE: Pivot Columns and Concatenate Text

Did you try this?
SELECT CustomerNr,
DeliveryWindow = 'Monday ' + MonDeliveryStartTime + '-' + MonDeliveryEndTime +
...
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

November 29, 2010 at 3:04 pm

#1256516
RE: Needed SQL DBA's (multiple positions contract/Full Time)

Craig Farrell (11/29/2010)
WayneS (11/29/2010)
CirquedeSQLeil (11/29/2010)
GilaMonster (11/29/2010)
Not quite sure how to take that. I'm 34 in a week and a day's time. 1994 was my final year of school.
Well, 92 was...
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

November 29, 2010 at 1:32 pm

#1256477
RE: Needed SQL DBA's (multiple positions contract/Full Time)

GilaMonster (11/29/2010)
WayneS (11/29/2010)
It was meant in a good way... I knew you had just finished up your masters...
More like 'finishing' 🙂
I started working after doing my Hons degree (B.Sc...
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

November 29, 2010 at 1:30 pm

#1256475
RE: Needed SQL DBA's (multiple positions contract/Full Time)

CirquedeSQLeil (11/29/2010)
GilaMonster (11/29/2010)
Not quite sure how to take that. I'm 34 in a week and a day's time. 1994 was my final year of school.
Well, 92 was my final year...
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

November 29, 2010 at 1:27 pm

#1256471
RE: Needed SQL DBA's (multiple positions contract/Full Time)

GilaMonster (11/29/2010)
WayneS (11/29/2010)
But either way...Jeez, that means you're older than I thought you were. 🙁
Not quite sure how to take that. I'm 34 in a week and a day's time....
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

November 29, 2010 at 1:20 pm

#1256469
RE: Pros and Cons for DR solutions

I think that this link will pretty much give you what you're looking for.
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

November 29, 2010 at 12:48 pm

#1256448
RE: Needed SQL DBA's (multiple positions contract/Full Time)

Craig Farrell (11/29/2010)
...If he approached you, Gail, Grant, Wayne, Jeff, etc... no, I would say it was money well spent. Generic hiring request without more specifics? Nah.
Looks like...
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

November 29, 2010 at 12:41 pm

#1256438

Viewing 15 posts - 2,251 through 2,265 (of 5,588 total)