WayneS

Forum Replies Created

Viewing 15 posts - 3,106 through 3,120 (of 5,588 total)

RE: Difference between sys.objects & sys.all_objects

pshaship (9/27/2010)
Hi,
What is the difference between the results displayed by sys.objects & sys.all_objects
Very simply, whether system objects are included or not.
sys.objects:
Contains a row for each user-defined, schema-scoped object that 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

September 27, 2010 at 5:42 pm

#1228100
RE: Parse data in field???

How's this?
-- See how this starts off with a table and data in it?
-- If you had provided us the data in this format,
-- it would have made things...
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 27, 2010 at 4:33 pm

#1228080
RE: Using BCP to export to a CSV file

Put your query in double-quotes. From BOL:
Use double quotation marks around the query and single quotation marks around anything embedded in the query.
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 27, 2010 at 2:30 pm

#1228008
RE: First Absence of the Week in a Monthly Pay Period

How's this?
-- See how this starts off with a table and data in it?
-- If you had provided us the data in this format,
-- it would have made things...
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 27, 2010 at 2:20 pm

#1228001
RE: Problems using OpenDataSource on production server to export to Excel

Brandie Tarvin (9/27/2010)
Wait. I'm confused. Are you selecting from an Excel spreadsheet or from a SQL Server table (dynamically generated)?
I know you're inserting INTO an Excel spreadsheet. I just don'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

September 27, 2010 at 2:13 pm

#1227990
RE: Need to split and combine some data in a query

Kit, did you get a working solution yet on this? (It seems like the solutions offered by Chris and Brandie are working.)
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 27, 2010 at 11:37 am

#1227865
RE: Are the posted questions getting worse?

Alvin Ramard (9/27/2010)
Alvin Ramard (9/27/2010)
WayneS (9/27/2010)
jcrawf02 (9/27/2010)
I of course immediately subscribed to your feed
Okay, stupid question time. How do you subscribe to a blog feed? Are any special programs required?
Since...
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 27, 2010 at 11:27 am

#1227853
RE: Are the posted questions getting worse?

jcrawf02 (9/27/2010)
Alvin Ramard (9/27/2010)
WayneS (9/27/2010)
jcrawf02 (9/27/2010)
I of course immediately subscribed to your feed
Okay, stupid question time. How do you subscribe to a blog feed? Are any special programs required?
Since you...
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 27, 2010 at 11:24 am

#1227846
RE: Problems using OpenDataSource on production server to export to Excel

Update: that didn't resolve it... back to square 1 :crying::angry:
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 27, 2010 at 11:16 am

#1227838
RE: Are the posted questions getting worse?

jcrawf02 (9/27/2010)
I of course immediately subscribed to your feed
Okay, stupid question time. How do you subscribe to a blog feed? Are any special programs required?
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 27, 2010 at 11:03 am

#1227825
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/27/2010)
Sometimes we learn quite a bit through our articles and our blogs that we would not have learned otherwise.
So true. In fact, the last article that I wrote...
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 27, 2010 at 9:15 am

#1227766
RE: I need some help with a test, please.

Jeff - just saw this thread after returning from my vacation. If needed, I can run this on a Vista Ultimate 64-bit laptop, on 2005 / 2008 (not R2). 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

September 26, 2010 at 10:32 pm

#1227503
RE: SQL Server's implementation of Window Functions

Phil Factor (9/26/2010)
Itzik has written a very fine blog on the subject of the missing functions Window Functions (OVER Clause) – Help Make a Difference. Also worth a look 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

September 26, 2010 at 2:11 pm

#1227478
RE: SQL Server's implementation of Window Functions

Itzik Ben-Gan has several connect items in an effort to get full support for the windowing functions added to SQL Server. If you're interested, see the following links:
(If you agree,...
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 26, 2010 at 11:46 am

#1227470
RE: Are the posted questions getting worse?

Brandie Tarvin (9/24/2010)
Wow. I just found the most interesting article on VSS Writer and backups through it... Thought I'd share.
Though I'm sure most of you have already seen it before:
http://technet.microsoft.com/en-us/library/ee923636(WS.10).aspx
Brandie,...
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 26, 2010 at 8:14 am

#1227457

Viewing 15 posts - 3,106 through 3,120 (of 5,588 total)