September 11, 2014 at 7:25 am
Managing a 4TB database and
Can you please guide me on how to find the root cause of log growth?
Really?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 11, 2014 at 7:26 am
SQLRNNR (9/11/2014)
Everything is awesome
And thanks for putting that in my head for the rest of the day... 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 11, 2014 at 7:26 am
Stefan Krzywicki (9/11/2014)
Oh thank goodness a reasonable answer. It isn't varchar(7) it is datetimeoffset(7)
That's disappointing--I was kind of hoping that the VARCHAR(7) date would turn out to be the octal number of days since March 17th 1936, or something equally exotic. 🙂
September 11, 2014 at 7:29 am
paul.knibbs (9/11/2014)
Stefan Krzywicki (9/11/2014)
Oh thank goodness a reasonable answer. It isn't varchar(7) it is datetimeoffset(7)That's disappointing--I was kind of hoping that the VARCHAR(7) date would turn out to be the octal number of days since March 17th 1936, or something equally exotic. 🙂
If I wasn't going to have anything to do with the database, I'd probably hope for that too.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 11, 2014 at 7:54 am
Koen Verbeeck (9/11/2014)
SQLRNNR (9/11/2014)
Everything is awesomeAnd thanks for putting that in my head for the rest of the day... 🙂
Everything is cool when you're part of ...BLAM! BLAM! BLAM! Make it stop!!!! 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 11, 2014 at 7:57 am
Koen Verbeeck (9/11/2014)
SQLRNNR (9/11/2014)
Everything is awesomeAnd thanks for putting that in my head for the rest of the day... 🙂
I've had the Pink Panther theme tune in my head all day.... (not the movie, the cartoon)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 11, 2014 at 8:55 am
GilaMonster (9/11/2014)
Koen Verbeeck (9/11/2014)
SQLRNNR (9/11/2014)
Everything is awesomeAnd thanks for putting that in my head for the rest of the day... 🙂
I've had the Pink Panther theme tune in my head all day.... (not the movie, the cartoon)
That's another good one.
Now to go find some Krazy Glue.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 11, 2014 at 8:56 am
Sean Lange (9/11/2014)
Koen Verbeeck (9/11/2014)
SQLRNNR (9/11/2014)
Everything is awesomeAnd thanks for putting that in my head for the rest of the day... 🙂
Everything is cool when you're part of ...BLAM! BLAM! BLAM! Make it stop!!!! 😛
https://www.youtube.com/watch?v=StTqXEQ2l-Y
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 11, 2014 at 9:01 am
SQLRNNR (9/11/2014)
Sean Lange (9/11/2014)
Koen Verbeeck (9/11/2014)
SQLRNNR (9/11/2014)
Everything is awesomeAnd thanks for putting that in my head for the rest of the day... 🙂
Everything is cool when you're part of ...BLAM! BLAM! BLAM! Make it stop!!!! 😛
That is good. The kids are going to love that one.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 11, 2014 at 9:45 am
PSA for the day...
If you're moving into a new home, make sure to take off at least a couple days before your move-in date to have a less stressful move. Coordinating everything with the wife via text and e-mail because she took the time off and you didn't is a royal PITA...
The more you know!
Yes, I'm moving into a new house Saturday, and have been working every day. The wife is doing her best to coordinate packing, movers, deliveries, etc to the new house, but needs my input. Then after work I've been going to the new house to hang curtains, blinds, and ceiling fans, plus dealing with problems with the cable (either the salesguy forgot to put HD on the order, or I forgot to order it {and I'm leaning towards the former}) Still need to build a set of steps for the back door (no patio / deck as yet, so it's a 2ft step down right now...)
Plus, Patch Tuesday was this week, so I need to get my QA servers patched up and watch for problems...
(head explodes)
September 11, 2014 at 9:50 am
jasona.work (9/11/2014)
PSA for the day...If you're moving into a new home, make sure to take off at least a couple days before your move-in date to have a less stressful move. Coordinating everything with the wife via text and e-mail because she took the time off and you didn't is a royal PITA...
The more you know!
Yes, I'm moving into a new house Saturday, and have been working every day. The wife is doing her best to coordinate packing, movers, deliveries, etc to the new house, but needs my input. Then after work I've been going to the new house to hang curtains, blinds, and ceiling fans, plus dealing with problems with the cable (either the salesguy forgot to put HD on the order, or I forgot to order it {and I'm leaning towards the former}) Still need to build a set of steps for the back door (no patio / deck as yet, so it's a 2ft step down right now...)
Plus, Patch Tuesday was this week, so I need to get my QA servers patched up and watch for problems...
(head explodes)
Sounds like a great time. Congratulations on the new house and move, but my condolences on having to move and set up a whole new home. Yes, definitely take a couple of days off. You know, I hear there's still 1.5 days left before Saturday. Don't worry about the 2 foot step for right now...moving in and being able to sleep there is more important.
September 11, 2014 at 9:59 am
Ed Wagner (9/11/2014)
jasona.work (9/11/2014)
PSA for the day...If you're moving into a new home, make sure to take off at least a couple days before your move-in date to have a less stressful move. Coordinating everything with the wife via text and e-mail because she took the time off and you didn't is a royal PITA...
The more you know!
Yes, I'm moving into a new house Saturday, and have been working every day. The wife is doing her best to coordinate packing, movers, deliveries, etc to the new house, but needs my input. Then after work I've been going to the new house to hang curtains, blinds, and ceiling fans, plus dealing with problems with the cable (either the salesguy forgot to put HD on the order, or I forgot to order it {and I'm leaning towards the former}) Still need to build a set of steps for the back door (no patio / deck as yet, so it's a 2ft step down right now...)
Plus, Patch Tuesday was this week, so I need to get my QA servers patched up and watch for problems...
(head explodes)
Sounds like a great time. Congratulations on the new house and move, but my condolences on having to move and set up a whole new home. Yes, definitely take a couple of days off. You know, I hear there's still 1.5 days left before Saturday. Don't worry about the 2 foot step for right now...moving in and being able to sleep there is more important.
Thanks, and yeah on the condolonces...
Still want to get some Cat5e strung, but that's gotten kicked so far down the list...
As for the step, it's going to wait, but not long, as the dog can't make the 2ft jump and she's going to want in, out, in, out, in, out...
:hehe:
September 11, 2014 at 10:44 am
jasona.work (9/11/2014)
Ed Wagner (9/11/2014)
jasona.work (9/11/2014)
PSA for the day...If you're moving into a new home, make sure to take off at least a couple days before your move-in date to have a less stressful move. Coordinating everything with the wife via text and e-mail because she took the time off and you didn't is a royal PITA...
The more you know!
Yes, I'm moving into a new house Saturday, and have been working every day. The wife is doing her best to coordinate packing, movers, deliveries, etc to the new house, but needs my input. Then after work I've been going to the new house to hang curtains, blinds, and ceiling fans, plus dealing with problems with the cable (either the salesguy forgot to put HD on the order, or I forgot to order it {and I'm leaning towards the former}) Still need to build a set of steps for the back door (no patio / deck as yet, so it's a 2ft step down right now...)
Plus, Patch Tuesday was this week, so I need to get my QA servers patched up and watch for problems...
(head explodes)
Sounds like a great time. Congratulations on the new house and move, but my condolences on having to move and set up a whole new home. Yes, definitely take a couple of days off. You know, I hear there's still 1.5 days left before Saturday. Don't worry about the 2 foot step for right now...moving in and being able to sleep there is more important.
Thanks, and yeah on the condolonces...
Still want to get some Cat5e strung, but that's gotten kicked so far down the list...
As for the step, it's going to wait, but not long, as the dog can't make the 2ft jump and she's going to want in, out, in, out, in, out...
:hehe:
Heh - We just got our driveway paved with asphalt on Tuesday (the day before the rain) and our dog doesn't know what to do any more. He can't tell where he's gone before, so he wanders around sniffing for where to go. I don't think I'll ever understand why location is so important to a dog in determining where to pee.
September 11, 2014 at 2:18 pm
Ed Wagner (9/11/2014)
Heh - We just got our driveway paved with asphalt on Tuesday (the day before the rain) and our dog doesn't know what to do any more. He can't tell where he's gone before, so he wanders around sniffing for where to go. I don't think I'll ever understand why location is so important to a dog in determining where to pee.
Dog gets to a new place, it wanders about and lays down boundary markers (scent). You tarmac over the boundary markers, the dog is still in the same place but some of its boundary markers have disappeared - very confusing for poor old dog.
Tom
September 11, 2014 at 2:54 pm
Ed Wagner (9/11/2014)
Heh - We just got our driveway paved with asphalt on Tuesday (the day before the rain) and our dog doesn't know what to do any more. He can't tell where he's gone before, so he wanders around sniffing for where to go. I don't think I'll ever understand why location is so important to a dog in determining where to pee.
It's important to humans as well. If you don't believe me, try peeing in the living room. 😀
Viewing 15 posts - 45,601 through 45,615 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply