September 9, 2016 at 2:03 pm
Sean Lange (9/9/2016)
Ed Wagner (9/9/2016)
Jeff Moden (9/9/2016)
Luis Cazares (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:
I think I found how I want to die. :hehe:
GAAAAHHHH!!!!! I shouldn't have looked! Now I'm so hungry that my stomach thinks my throat has been cut. 😛 MAN! Those sandwiches that the shakes look awesome! I wonder if they'd deliver to Troy, Michigan for lunch. :w00t:
That looks like the BLT at Tony's in Birch Run, MI. Their sandwiches are huge and come with no less than 1 pound of bacon. Sorry, Jeff, but they don't deliver.
Ohhh I have to try this place. I found their BLT on the online menu....it is the first item listed on the "lighter side" page. ROFL!!!!!
http://www.tonysi75restaurant.com/sandwiches-bull-lighter-side.html
Their breakfasts come with 1 pound of bacon as well. 😀
Edit: I'll be sure to let you know when the SQL Saturday gets scheduled for Detroit.
September 9, 2016 at 2:10 pm
I just spent 5 minutes trying to figure out whey this INSERT statement was failing:
CREATE TABLE dbo.MyTable
(
SocialAdvertisingDimAdKey int IDENTITY(1,1) NOT NULL,
SocialAdvertisingDimCampaignKey bigint NOT NULL,
SourceDimKey int NOT NULL,
[Source] varchar(12) NOT NULL,
ADID bigint NOT NULL,
AdGroupID bigint NOT NULL,
AdGroupName varchar(700) NOT NULL,
CampaignObjective varchar(250) NOT NULL
)
GO
INSERT dbo.MyTable
(
SocialAdvertisingDimCampaignKey
SourceDimKey
[Source]
ADID
AdGroupID
AdGroupName
CampaignObjective
)
SELECT 1,1,1,1,1,1,1
I think that's my brains way of telling me that I should declare the work week over and go home!
-- Itzik Ben-Gan 2001
September 9, 2016 at 3:04 pm
Jeff, if you're in Troy looks like you're just over an hour away from the BLT in Birch Run. They might deliver for the right price. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 9, 2016 at 3:06 pm
Alan.B (9/9/2016)
I just spent 5 minutes trying to figure out whey this INSERT statement was failing
"Whey" is the second hint. Have a great weekend 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 9, 2016 at 3:08 pm
The Dixie Flatline (9/9/2016)
Alan.B (9/9/2016)
I just spent 5 minutes trying to figure out whey this INSERT statement was failing"Whey" is the second hint. Have a great weekend 😀
You too. Cheers
-- Itzik Ben-Gan 2001
September 9, 2016 at 3:41 pm
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:
Okay, that looks like a bacon, bacon, bacon, bacon, bacon, lettuce, tomato sandwich. A definite must try if I get out there.
September 9, 2016 at 6:21 pm
Lynn Pettis (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:
Okay, that looks like a bacon, bacon, bacon, bacon, bacon, lettuce, tomato sandwich. A definite must try if I get out there.
So it has plenty of "B" vitamins. They just need to add a little more bacon to get "bacon, bacon, bacon, bacon, bacon, bacon", which is vitamin "B6", no? 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
September 9, 2016 at 6:48 pm
J Livingston SQL (9/9/2016)
feeling pleased (for the minute!)
off the shelf tower.....6th Generation Intel(R) Core(TM) i7-6700 Processor (8M Cache, up to 4.0 GHz)
16GB (2x8GB) 2133MHz DDR4 Non-ECC 1 SR
2TB 7200 rpm Hard Drive + 32GB M.2 SSD Cache
Microsoft SQL Server 2016 Developer Edition (64-bit) on Windows 10 Home 6.3 <X64> (Build 14393: )
Table 'SomeTable'. Scan count 1, logical reads 210085, 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 = 19640 ms, elapsed time = 19711 ms.
(100000000 row(s) affected)
What was the test code that you ran for this test? We all ought to run it, and post our results on the Thread. You know... more points for us. Possibly bragging rights.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 9, 2016 at 9:30 pm
Today is SQLSaturday Cambridge. Gianluca is here if anyone wants to say hello. Not sure which other Threadizens. Assuming we all don't get eaten by a Grue.
"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 9, 2016 at 9:33 pm
Grant Fritchey (9/9/2016)
Today is SQLSaturday Cambridge. Gianluca is here if anyone wants to say hello. Not sure which other Threadizens. Assuming we all don't get eaten by a Grue.
Howdy Gianluca
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 9, 2016 at 9:45 pm
Alan.B (9/9/2016)
I just spent 5 minutes trying to figure out whey this INSERT statement was failing:
CREATE TABLE dbo.MyTable(
SocialAdvertisingDimAdKey int IDENTITY(1,1) NOT NULL,
SocialAdvertisingDimCampaignKey bigint NOT NULL,
SourceDimKey int NOT NULL,
[Source] varchar(12) NOT NULL,
ADID bigint NOT NULL,
AdGroupID bigint NOT NULL,
AdGroupName varchar(700) NOT NULL,
CampaignObjective varchar(250) NOT NULL
)
GO
INSERT dbo.MyTable
(
SocialAdvertisingDimCampaignKey
SourceDimKey
[Source]
ADID
AdGroupID
AdGroupName
CampaignObjective
)
SELECT 1,1,1,1,1,1,1
I think that's my brains way of telling me that I should declare the work week over and go home!
Punctuation marks do matter, amazing what few commas can do;-)
😎
INSERT dbo.MyTable
(
SocialAdvertisingDimCampaignKey
,SourceDimKey
,[Source]
,ADID
,AdGroupID
,AdGroupName
,CampaignObjective
)
September 9, 2016 at 11:53 pm
WayneS (9/9/2016)
J Livingston SQL (9/9/2016)
feeling pleased (for the minute!)
off the shelf tower.....6th Generation Intel(R) Core(TM) i7-6700 Processor (8M Cache, up to 4.0 GHz)
16GB (2x8GB) 2133MHz DDR4 Non-ECC 1 SR
2TB 7200 rpm Hard Drive + 32GB M.2 SSD Cache
Microsoft SQL Server 2016 Developer Edition (64-bit) on Windows 10 Home 6.3 <X64> (Build 14393: )
Table 'SomeTable'. Scan count 1, logical reads 210085, 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 = 19640 ms, elapsed time = 19711 ms.
(100000000 row(s) affected)
What was the test code that you ran for this test? We all ought to run it, and post our results on the Thread. You know... more points for us. Possibly bragging rights.
Here is a suggestion
😎
USE TEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.TBL_NUMBERS') IS NOT NULL DROP TABLE dbo.TBL_NUMBERS;
CREATE TABLE dbo.TBL_NUMBERS
(
N INT NOT NULL CONSTRAINT PK_DBO_TBL_NUMBERS_N PRIMARY KEY CLUSTERED
);
-- This will add approx. 1 Gb worth of data to the table. Note that if fully logged then the
-- log file will grow close to 20 times the data size!
DECLARE @SAMPLE_SIZE INT = 100000000;
;WITH T(N) AS (SELECT N FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS X(N))
, NUMS(N) AS (SELECT TOP(@SAMPLE_SIZE) ROW_NUMBER() OVER (ORDER BY (@@VERSION)) AS N FROM T T1,T T2,T T3,T T4,T T5,T T6,T T7,T T8,T T9)
INSERT INTO dbo.TBL_NUMBERS WITH (TABLOCK)(N)
SELECT
NM.N
FROM NUMS NM;
-- Slightly faster than the clustered index, almost 1 Gb of additionals storage needed.
CREATE UNIQUE NONCLUSTERED INDEX UNQNCLIDX_DBO_TBL_NUMBERS_N ON dbo.TBL_NUMBERS (N ASC);
-- SQL Server Version
SELECT @@VERSION;
-- Very simple test into a bucket variable.
DECLARE @INT_BUCKET INT = 0;
RAISERROR('
-------------------------------------------------------------------------------
-- FIRST READ
-------------------------------------------------------------------------------',0,0) WITH NOWAIT;
SET STATISTICS IO,TIME ON;
SELECT
@INT_BUCKET = NM.N
FROM dbo.TBL_NUMBERS NM
SET STATISTICS TIME,IO OFF;
RAISERROR('
-------------------------------------------------------------------------------
-- SECOND READ
-------------------------------------------------------------------------------',0,0) WITH NOWAIT;
SET STATISTICS IO,TIME ON;
SELECT
@INT_BUCKET = NM.N
FROM dbo.TBL_NUMBERS NM
SET STATISTICS TIME,IO OFF;
RAISERROR('
-------------------------------------------------------------------------------
-- THIRD READ
-------------------------------------------------------------------------------',0,0) WITH NOWAIT;
SET STATISTICS IO,TIME ON;
SELECT
@INT_BUCKET = NM.N
FROM dbo.TBL_NUMBERS NM
SET STATISTICS TIME,IO OFF;
Results from my old 2nd gen i5 laptop
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2016 (RTM-GDR) (KB3164398) - 13.0.1708.0 (X64)
Jun 2 2016 07:18:56
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Pro 6.3 <X64> (Build 10586: )
-------------------------------------------------------------------------------
-- FIRST READ
-------------------------------------------------------------------------------
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 = 12329 ms, elapsed time = 12349 ms.
-------------------------------------------------------------------------------
-- SECOND READ
-------------------------------------------------------------------------------
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 = 12359 ms, elapsed time = 12532 ms.
-------------------------------------------------------------------------------
-- THIRD READ
-------------------------------------------------------------------------------
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 = 12484 ms, elapsed time = 12538 ms.
September 10, 2016 at 1:34 am
WayneS (9/9/2016)
J Livingston SQL (9/9/2016)
feeling pleased (for the minute!)
off the shelf tower.....6th Generation Intel(R) Core(TM) i7-6700 Processor (8M Cache, up to 4.0 GHz)
16GB (2x8GB) 2133MHz DDR4 Non-ECC 1 SR
2TB 7200 rpm Hard Drive + 32GB M.2 SSD Cache
Microsoft SQL Server 2016 Developer Edition (64-bit) on Windows 10 Home 6.3 <X64> (Build 14393: )
Table 'SomeTable'. Scan count 1, logical reads 210085, 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 = 19640 ms, elapsed time = 19711 ms.
(100000000 row(s) affected)
What was the test code that you ran for this test? We all ought to run it, and post our results on the Thread. You know... more points for us. Possibly bragging rights.
Gails code on the "Division by Zero NULL" thread
http://www.sqlservercentral.com/Forums/FindPost1816374.aspx
________________________________________________________________
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 1:51 am
Eirikur Eiriksson
-------------------------------------------------------------------------------
-- FIRST READ
-------------------------------------------------------------------------------
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 = 12329 ms, elapsed time = 12349 ms.
-------------------------------------------------------------------------------
-- SECOND READ
-------------------------------------------------------------------------------
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 = 12359 ms, elapsed time = 12532 ms.
-------------------------------------------------------------------------------
-- THIRD READ
-------------------------------------------------------------------------------
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 = 12484 ms, elapsed time = 12538 ms.
6th Generation Intel(R) Core(TM) i7-6700 / 16GB DDR4 /2TB 7200 rpm Hard Drive + 32GB M.2 SSD Cache
Microsoft SQL Server 2016 Developer Edition (64-bit) on Windows 10 Home 6.3 <X64> (Build 14393: )
-------------------------------------------------------------------------------
-- FIRST READ
-------------------------------------------------------------------------------
Table 'TBL_NUMBERS'. Scan count 1, logical reads 123818, physical reads 0, read-ahead reads 48, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 7734 ms, elapsed time = 7744 ms.
-------------------------------------------------------------------------------
-- SECOND READ
-------------------------------------------------------------------------------
Table 'TBL_NUMBERS'. Scan count 1, logical reads 123818, 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 = 7719 ms, elapsed time = 7731 ms.
-------------------------------------------------------------------------------
-- THIRD READ
-------------------------------------------------------------------------------
Table 'TBL_NUMBERS'. Scan count 1, logical reads 123818, 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 = 7922 ms, elapsed time = 7920 ms.
________________________________________________________________
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 6:12 am
J Livingston SQL (9/10/2016)
6th Generation Intel(R) Core(TM) i7-6700 / 16GB DDR4 /2TB 7200 rpm Hard Drive + 32GB M.2 SSD Cache
Microsoft SQL Server 2016 Developer Edition (64-bit) on Windows 10 Home 6.3 <X64> (Build 14393: )
-------------------------------------------------------------------------------
-- FIRST READ
-------------------------------------------------------------------------------
Table 'TBL_NUMBERS'. Scan count 1, logical reads 123818, physical reads 0, read-ahead reads 48, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
SQL Server Execution Times:
CPU time = 7734 ms, elapsed time = 7744 ms.
-------------------------------------------------------------------------------
-- SECOND READ
-------------------------------------------------------------------------------
Table 'TBL_NUMBERS'. Scan count 1, logical reads 123818, 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 = 7719 ms, elapsed time = 7731 ms.
-------------------------------------------------------------------------------
-- THIRD READ
-------------------------------------------------------------------------------
Table 'TBL_NUMBERS'. Scan count 1, logical reads 123818, 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 = 7922 ms, elapsed time = 7920 ms.
Pretty impressive!
😎
Viewing 15 posts - 55,741 through 55,755 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply