« first day (1198 days earlier)      last day (3671 days later) » 
01:00 - 19:0019:00 - 22:00

Max Vernon
Max Vernon
7:00 PM
the average file size of each vlf on that instance is 132 BYTES.
10% log file growth
 
billinkc
billinkc
Death by 2.9B cuts
2
 
Max Vernon
Max Vernon
NO DOUBT!
 
billinkc
billinkc
This is going to take some arcane magic and wizardry to fix your performance issues. I'll need a few weeks of working in complete solace /snicker
 
Max Vernon
Max Vernon
you got it, Bill
I keep trying not to snicker but is real hard
I had a overflow error trying to fit the number of VLFs into an INT.
thats never happened to me before
thanks Bill!
 
billinkc
billinkc
Didn't realize I wasn't following you. I'll blame the twitters for an unfollow
 
Max Vernon
Max Vernon
7:07 PM
lol!
oh, @swasheck - I just realized I didn't reply to your message from a while back. Yes I got a new gig. And now it seems I've been offered another gig. When it rains it pours!
 
Zane
Zane
Speaking of raining. We are getting hit by snow and freezing rain!
 
Max Vernon
Max Vernon
damn @Zane I feel for you! We still have snow on the ground here although it is melting pretty fast - should be gone in a week or two I'd expect.
oh and when these guys need to make a copy of a database, they detach, copy, and reattach instead of backup/restore. that makes for much fun.
 
Kermit
Kermit
7:30 PM
@Lamak way to go
@Lamak - thank you very much this solved my problem. — user2029074 3 mins ago
 
Lamak
Lamak
@Kermit thank you
sigh people don't understand what tools to use for their requirements
0
Q: SSRS 2008 Is it possible to Dynamically delete a row in a dataset and assign it's value to column

Mickey SlyI've created a trading report in SSRS based on a stored procedure of mine. Basically I have a dataset with the fields ID, Name, Type, Price, Volume and a new row SwapName. What I want to do is if Type is value "SWAP" I want to look up the corresponding row in the dataset. Take that row's name and...

sql sql-server reporting-services ssrs-2008 ssrs-2008-r2
 
swasheck
swasheck
7:56 PM
@MaxVernon not a bad problem to have
@MaxVernon are you able to see your worst vlf offenders?
 
Max Vernon
Max Vernon
@swasheck I'm looking at them using DBCC LOGINFO scripted into a temp table. However, I made a mistake with the total VLF count, it is "only" 1,363,588... still a fare number!
damn I hate being wrong lol!
 
swasheck
swasheck
@MaxVernon apologies for the sp_msforeachdb ... i stole it from Tripp and added a few things of my own
 
Zane
Zane
8:21 PM
You know I love the idea of Intellisense. I think they main thing they need to do is make it work consistently.
 
swasheck
swasheck
ahemSQLPromptahem
 
Zane
Zane
zero chance of that happening my friend.
 
billinkc
billinkc
Intellisense is vastly improved in 2012 vs 2008
But yes, SQL Prompt >> Intellisense
 
Zane
Zane
GETDATE() kicks ass.
 
billinkc
billinkc
Heathen. CURRENT_TIMESTAMP is where it's at
 
Zane
Zane
8:32 PM
@billinkc I find 2012 tends to drop out on me.
 
billinkc
billinkc
You're a drop out
 
Zane
Zane
oh man. Now my feeling are hurt...
 
billinkc
billinkc
Weep. Weep tears of inadequacy
 
Max Vernon
Max Vernon
@swasheck thanks Seth!
 
swasheck
swasheck
yep
and the nolocks are artifacts from glenn berry
 
Paul White
Paul White
8:39 PM
Hard to believe there still isn't a DMV to replace DBCC LOGINFO.
 
swasheck
swasheck
@PaulWhite also hard to believe that there's not a decent DMV to replace DBCC SHOW_STATISTICS
 
Paul White
Paul White
SSMS Intellisense is better than nothing, but not by much.
2
@swasheck Right, but at least they made on a start on the general area with sys.dm_db_stats_properties.
 
swasheck
swasheck
well-begun is half-done
 
Paul White
Paul White
I believe that's their official motto these days.
cough Hekaton cough
 
Zane
Zane
8:52 PM
Plan explorer pro's ability to cut through our shitty obfuscation never ceases to amaze me.
 
Mike Fal
Mike Fal
Yes, but can it un-obfuscate @Kermit's email?
 
bluefeet
bluefeet
@MikeFal it's the Wizard of Oz - all knowing
 
swasheck
swasheck
@PaulWhite ouch
 
Zane
Zane
9:46 PM
Looks like my roommate is coming with to Chicago.
 
ypercube
ypercube
I went to Greece for Easter but the weather decided it was Christmas
 
01:00 - 19:0019:00 - 22:00

« first day (1198 days earlier)      last day (3671 days later) »