Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9263,9273,9283,9293,930»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, March 29, 2013 5:30 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 23,299, Visits: 32,047
Not that I don't believe, is there anything I can do to see this? I may not have the time right now but this could be something I could look into more myself when I have more down time, like off hours while in Afghanistan.

I mean really, what else will there be to do if not working.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437146
Posted Friday, March 29, 2013 5:38 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:27 AM
Points: 42,829, Visits: 35,960
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?


Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and the kb article that it links to.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1437148
Posted Friday, March 29, 2013 5:43 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 23,299, Visits: 32,047
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?


Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and the kb article that it links to.


Okay, sounds good to me. I have few months before I go, just not sure if I can make the time before hand. Definitely give me something to do while not working or sleeping.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437149
Posted Friday, March 29, 2013 6:16 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 23,299, Visits: 32,047
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?


Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and the kb article that it links to.


Okay, sounds good to me. I have few months before I go, just not sure if I can make the time before hand. Definitely give me something to do while not working or sleeping.


Well, I had a quick read, now all I need is more time to actually play with this myself and see how things work. May even do it before going to Afghanistan, but we will have to see. Definitely something to do while there though.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437161
Posted Saturday, March 30, 2013 11:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:04 PM
Points: 6,594, Visits: 8,882
Lynn Pettis (3/29/2013)
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?


Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and the kb article that it links to.


Okay, sounds good to me. I have few months before I go, just not sure if I can make the time before hand. Definitely give me something to do while not working or sleeping.


Well, I had a quick read, now all I need is more time to actually play with this myself and see how things work. May even do it before going to Afghanistan, but we will have to see. Definitely something to do while there though.


If you can make it to a SQLSaturday where I'm presenting my Table Variables / Temp Tables, I demo this.


Wayne
Microsoft Certified Master: SQL Server 2008
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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1437214
Posted Saturday, March 30, 2013 12:47 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:58 AM
Points: 36,995, Visits: 31,517
Koen Verbeeck (3/28/2013)
Totally unrelated - as usual in this topic - I got the MCSE Business Intelligence certificate today.
Because someone has to answer all those BI questions on this forum


Very cool. Way to go Koen!


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1437221
Posted Saturday, March 30, 2013 1:35 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
WayneS (3/30/2013)
Lynn Pettis (3/29/2013)
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?


Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and the kb article that it links to.


Okay, sounds good to me. I have few months before I go, just not sure if I can make the time before hand. Definitely give me something to do while not working or sleeping.


Well, I had a quick read, now all I need is more time to actually play with this myself and see how things work. May even do it before going to Afghanistan, but we will have to see. Definitely something to do while there though.


If you can make it to a SQLSaturday where I'm presenting my Table Variables / Temp Tables, I demo this.


Two suggestions for you then:

SQLSat in Denver this September

And
SQL Sat in SLC (sometime in the fall but not yet scheduled).




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1437233
Posted Saturday, March 30, 2013 5:43 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 23,299, Visits: 32,047
SQLRNNR (3/30/2013)
WayneS (3/30/2013)
Lynn Pettis (3/29/2013)
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?


Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and the kb article that it links to.


Okay, sounds good to me. I have few months before I go, just not sure if I can make the time before hand. Definitely give me something to do while not working or sleeping.


Well, I had a quick read, now all I need is more time to actually play with this myself and see how things work. May even do it before going to Afghanistan, but we will have to see. Definitely something to do while there though.


If you can make it to a SQLSaturday where I'm presenting my Table Variables / Temp Tables, I demo this.


Two suggestions for you then:

SQLSat in Denver this September

And
SQL Sat in SLC (sometime in the fall but not yet scheduled).



Sorry but I will be 7700 miles away in Kabul, Afghanistan.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437254
Posted Saturday, March 30, 2013 5:45 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, August 29, 2014 1:51 PM
Points: 21,644, Visits: 15,317
Lynn Pettis (3/30/2013)
SQLRNNR (3/30/2013)
WayneS (3/30/2013)
Lynn Pettis (3/29/2013)
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?


Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and the kb article that it links to.


Okay, sounds good to me. I have few months before I go, just not sure if I can make the time before hand. Definitely give me something to do while not working or sleeping.


Well, I had a quick read, now all I need is more time to actually play with this myself and see how things work. May even do it before going to Afghanistan, but we will have to see. Definitely something to do while there though.


If you can make it to a SQLSaturday where I'm presenting my Table Variables / Temp Tables, I demo this.


Two suggestions for you then:

SQLSat in Denver this September

And
SQL Sat in SLC (sometime in the fall but not yet scheduled).



Sorry but I will be 7700 miles away in Kabul, Afghanistan.



How long are you going to be there?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1437255
Posted Saturday, March 30, 2013 5:49 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 23,299, Visits: 32,047
SQLRNNR (3/30/2013)
Lynn Pettis (3/30/2013)
SQLRNNR (3/30/2013)
WayneS (3/30/2013)
Lynn Pettis (3/29/2013)
Lynn Pettis (3/29/2013)
GilaMonster (3/29/2013)
Lynn Pettis (3/29/2013)
Not that I don't believe, is there anything I can do to see this?


Read my blog?
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/ Third section, "Changes to Table Variables are not logged" and the kb article that it links to.


Okay, sounds good to me. I have few months before I go, just not sure if I can make the time before hand. Definitely give me something to do while not working or sleeping.


Well, I had a quick read, now all I need is more time to actually play with this myself and see how things work. May even do it before going to Afghanistan, but we will have to see. Definitely something to do while there though.


If you can make it to a SQLSaturday where I'm presenting my Table Variables / Temp Tables, I demo this.


Two suggestions for you then:

SQLSat in Denver this September

And
SQL Sat in SLC (sometime in the fall but not yet scheduled).



Sorry but I will be 7700 miles away in Kabul, Afghanistan.



How long are you going to be there?


Supposed to be 6 months but I'm hoping to try and extend it to 12 months (I would like the tax break for working overseas for a year).



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1437256
« Prev Topic | Next Topic »

Add to briefcase «««3,9263,9273,9283,9293,930»»»

Permissions Expand / Collapse