September 10, 2016 at 8:24 am
What have I started here?! Haha
September 10, 2016 at 8:26 am
Gazareth (9/10/2016)
What have I started here?! Haha
go on...show us yours:-D
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 10, 2016 at 9:15 am
Here is my ailing old work station
😎
OS Name Microsoft Windows 10 Enterprise
Version 10.0.10586 Build 10586
Processor Intel(R) Core(TM) i5-3470 CPU @ 3.20GHz, 3201 Mhz, 4 Core(s), 4 Logical Processor(s)
Installed Physical Memory (RAM) 12.0 GB
Total Physical Memory 12.0 GB
Available Physical Memory 4.60 GB
Total Virtual Memory 13.8 GB
Available Virtual Memory 2.91 GB
---------------------------------------------------------------------------------------------------
Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64)
Apr 29 2016 23:23:58
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Enterprise 6.3 <X64> (Build 10586: ) (Hypervisor)
-------------------------------------------------------------------------------
-- FIRST READ
-------------------------------------------------------------------------------
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
Table 'TBL_NUMBERS'. Scan count 1, logical reads 123814, physical reads 0, read-ahead reads 20, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 10516 ms, elapsed time = 10540 ms.
-------------------------------------------------------------------------------
-- SECOND READ
-------------------------------------------------------------------------------
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
Table 'TBL_NUMBERS'. Scan count 1, logical reads 123814, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 10484 ms, elapsed time = 10502 ms.
-------------------------------------------------------------------------------
-- THIRD READ
-------------------------------------------------------------------------------
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
Table 'TBL_NUMBERS'. Scan count 1, logical reads 123814, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 10641 ms, elapsed time = 10904 ms.
Edit: Correction
September 12, 2016 at 2:19 am
Greg Edwards-268690 (9/9/2016)
Sean Lange (9/9/2016)
The Dixie Flatline (9/9/2016)
I have been making bacon like that for years...never knew it had a name. Another great way is to put a liberal amount of brown sugar on top of the raw bacon and bake them on a sheet pan. Super sticky but holy cow is it tasty.
Yeah we bake it on a sheet pan too. You should try the Pecan-Rosemary. You'll never look at a BLT sandwich the same way again.
That does sound good. Of course it will challenging fro any BLT to rival the behemoth found at Crown Candy in St. Louis. It is only $9 but man is it under priced. Check out some pics of it....https://www.google.com/search?q=crown+candy+blt&biw=1920&bih=914&source=lnms&tbm=isch&sa=X&ved=0ahUKEwie_4bL9ILPAhUIJ5oKHSr9AvIQ_AUICCgB
I can only imagine if it had the pecan-rosemary bacon on it. :w00t::w00t::w00t:
What timing. Fishing with the guys all this week, and it's usually a couple pounds of bacon per day.
I am more than ready to get on the road.
Wow you catch that much bacon when fishing... I must be using the wrong bait :w00t:
Rodders...
September 12, 2016 at 2:21 am
Grant, Gianluca, Steve and whoever else was at SQL Sat Cambridge. Hope you all had a great time.
Pity I couldn't make it, but I had other plans on Saturday :O
Gail, how goes your marathon of presenting at SQL Sats? Have you done them all or do you still have one left?
Cheers,
Rodders...
September 12, 2016 at 3:31 am
rodjkidd (9/12/2016)
Gail, how goes your marathon of presenting at SQL Sats? Have you done them all or do you still have one left?
Two down, one to go (and a seminar at a local university)
And, heaven help me, there's talk about adding SQLSaturday Port Elizabeth to the sequence next year.
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 12, 2016 at 3:33 am
It was a good event. I especially enjoyed how Mark took advantage of the space and created little mini-cons for people in small rooms that wouldn't otherwise get used. I need to write it up as a PASS blog post. I think others ought to emulate it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 12, 2016 at 3:37 am
GilaMonster (9/12/2016)
rodjkidd (9/12/2016)
Gail, how goes your marathon of presenting at SQL Sats? Have you done them all or do you still have one left?Two down, one to go (and a seminar at a local university)
And, heaven help me, there's talk about adding SQLSaturday Port Elizabeth to the sequence next year.
Oh nice, well it will keep you busy!
Rodders...
September 12, 2016 at 10:00 am
Well, I'm back and things seem to still be working.
SAL Sat Cambridge was fun, and good to see a few people from the Thread there. Sorry you weren't there, Rodney.
September 12, 2016 at 10:04 am
Steve Jones - SSC Editor (9/12/2016)
Well, I'm back and things seem to still be working.SAL Sat Cambridge was fun, and good to see a few people from the Thread there. Sorry you weren't there, Rodney.
Well I guess we will see each other at Summit next... Wow!
Rodders...
September 13, 2016 at 7:46 am
Anyone willing to share general stats on their blogs. ( Or is this a rude request??!)
I have received 1000 views within the past 6 months which is poor ( but expected as Im quite new).. I am just trying to understand the sort of view hit the elite bloggers get... i.e. the MVPs / MCMs of this world. I'm guessing you guys hit many many many thousands over the month??
September 13, 2016 at 7:56 am
~300-500 per day, except weekends.
iirc I suggested ignoring blog stats initially...
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 13, 2016 at 8:01 am
GilaMonster (9/13/2016)
~300-500 per day, except weekends.iirc I suggested ignoring blog stats initially...
wow amazing figures. Yep I should ignore it, I just use it to confirm that I get at least "some" views. Makes me a little happy that I get between 10-30 views a post....:w00t:
thanks for sharing your view number.
September 13, 2016 at 8:07 am
GilaMonster (9/13/2016)
~300-500 per day, except weekends.iirc I suggested ignoring blog stats initially...
I'm sure at least 1% of your traffic is me repeatedly reading your 'CATCH ALL QUERIES' post 😀
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 13, 2016 at 8:08 am
My last blog was posted August 31, and now has 3817 views.
The post before that was from June 25, and is now up to 7848 views.
Since my blog is on the sqlblog.com site, I think I get a lot of "free" traffic from people who read all posts on that side.
On the other hand, my very irregular posting pattern (e.g., no posts at all between Nov 6, 2014 and June 25, 2016) probably hurts my numbers a lot.
Viewing 15 posts - 55,756 through 55,770 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply