WayneS

Forum Replies Created

Viewing 15 posts - 1,606 through 1,620 (of 5,588 total)

RE: temp table vs. table variable

reto.eggenberger (3/29/2011)
Hi all
I was able to dramatically improve the procedure. But I had to rewrite the whole section. I didn't want to do this (since it's not an application we...
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

March 29, 2011 at 7:54 am

#1304867
RE: temp table vs. table variable

CirquedeSQLeil (3/28/2011)
It looks like somebody needs an errata submission for this book. Table variables are not entirely memory resident. They do incur IO cost and can be quite...
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

March 29, 2011 at 7:48 am

#1304862
RE: temp table vs. table variable

jeedee (3/28/2011)
May I ask why you prefer temporary tables above table variables?
Almost all the books I have read about SQL Server state that it's better to use table variables than...
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

March 29, 2011 at 7:40 am

#1304856
RE: Are the posted questions getting worse?

Kiara (3/29/2011)
I'm going to take a moment and thank you all yet again for help that you didn't know you just provided.
I just spent about 45 minutes writing out a...
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

March 29, 2011 at 7:15 am

#1304832
RE: Deadlock on a single resource ?

Those selects are doing a "select top 30" - do you have an order by on this query? If so, check to see if you have index(es) that will cover...
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

March 28, 2011 at 1:09 pm

#1304534
RE: Deadlock on a single resource ?

Can you post the deadlock xml information?
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

March 28, 2011 at 10:04 am

#1304456
RE: Problem: how to realize custom order

Birby1974 (3/27/2011)
Guys, thankyou very much for all your answers.
I'm reading all your posts in this moment, because I just got back from a romantic weekend !!
🙂
If you're having a romantic...
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

March 27, 2011 at 2:46 pm

#1304124
RE: Shrink Database in Simple Recovery Mode

Sachin Nandanwar (3/27/2011)
Wayne now your explanation is exactly SPOT ON.Now the whole process has become crystal clear to me just like the cookie analogy Brandie had posted earlier.
Thanks to 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

March 27, 2011 at 2:42 pm

#1304121
RE: Shrink Database in Simple Recovery Mode

You might also want to take a look at this BOL entry: Checkpoints and the Active Portion of the Log
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

March 27, 2011 at 12:53 pm

#1304089
RE: Are the posted questions getting worse?

Grant Fritchey (3/27/2011)
Jeff Moden (3/26/2011)
Koen Verbeeck (3/25/2011)
Maybe an article on why it is not necessary to maintain indexes. Who needs them right?
(but maybe again, someone picks this up not realizing...
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

March 27, 2011 at 12:50 pm

#1304088
RE: Shrink Database in Simple Recovery Mode

Those videos will really explain how, internally, the log file works.
I'm going to attempt to explain it here, with the caveat that if what I say happens to be different...
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

March 27, 2011 at 12:44 pm

#1304087
RE: Shrink Database in Simple Recovery Mode

Sachin Nandanwar (3/27/2011)
GilaMonster (3/25/2011)
No.
SQL writes data modifications to data pages in the data cache. It writes the log records to disk at the point the transaction is committed (or sometimes...
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

March 27, 2011 at 11:17 am

#1304074
RE: How to return hrs,mins and secs from a function when date time stamp is passed to that function..

srividyakudumula (3/27/2011)
Can you take these dates and check :
@date1 = 2011-03-27 20:13:31.640
@date2 = '2011-05-27 00:00:00'
using sql server 2008
Output:
DaysHoursMinutesSeconds
6034629
can you explain me how this is correct for (hrs,mins and secs)..
May be...
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

March 27, 2011 at 11:06 am

#1304071
RE: How to return hrs,mins and secs from a function when date time stamp is passed to that function..

sunitabeck (3/27/2011)
"start of sql rally", Wayne?! :--)
Made me look up what it is... thanks for using that as an example!
No problem - I figured I'd have a little fun...
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

March 27, 2011 at 10:52 am

#1304070
RE: Shrink Database in Simple Recovery Mode

Brandie Tarvin (3/25/2011)
GilaMonster (3/25/2011)
The IO docs I referred you to should make it clear that SQL does not move data from log to data file during a checkpoint, and given...
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

March 27, 2011 at 10:39 am

#1304068

Viewing 15 posts - 1,606 through 1,620 (of 5,588 total)