Viewing 15 posts - 1,441 through 1,455 (of 2,463 total)
DMV's are views, DMF's are functions. Dynamic Management Views and Functions were introduced in SQL 2005 and allow you to look at information that is stored in the Query Cache,...
-- Itzik Ben-Gan 2001
May 29, 2015 at 12:06 am
I think this is one of the areas where our profession will grow more and more across the next decade. As we deal with lots of data of varying types,...
-- Itzik Ben-Gan 2001
May 28, 2015 at 11:52 pm
You've been around enough to know about posting DLL, sample data, etc... You're also posting the estimated query plan. The actual query plan would be better.
Anyhow, from a birds-eye...
-- Itzik Ben-Gan 2001
May 28, 2015 at 11:10 pm
Gary Harding (5/28/2015)
Alan.B (5/27/2015)
Michael Meierruth (5/27/2015)
Alan B.How does your function stand up to a varchar(8000) column with an * at the beginning and end and all blanks in between?
Okay, first...
-- Itzik Ben-Gan 2001
May 28, 2015 at 8:27 pm
I wrote a numbers function some time ago that is designed for exactly this type of thing.
IF OBJECT_ID('dbo.GetNumsAB','IF') IS NOT NULL
DROP FUNCTION dbo.GetNumsAB;
GO
CREATE FUNCTION dbo.GetNumsAB(@low int, @high int, @range...
-- Itzik Ben-Gan 2001
May 28, 2015 at 8:17 pm
Brandie Tarvin (5/28/2015)
Alan.B (5/27/2015)
Does the lack of deterministic causality invalidate quantum mechanics?
It Depends.
Alan, can I just say I adore you right now for putting this together. @=)
LOVE IT.
😛
-- Itzik Ben-Gan 2001
May 28, 2015 at 8:03 am
David Burrows (5/28/2015)
Jeff Moden (5/24/2015)
-- Itzik Ben-Gan 2001
May 28, 2015 at 7:55 am
GilaMonster (5/27/2015)
SQLRNNR (5/27/2015)
GilaMonster (5/27/2015)
Looks like I hit a few nerves with Sunday's editorial....Two words...
Ugh
Troll
I'd reply and point out the flaw in his logic (he's got scientific method and scientific consensus...
-- Itzik Ben-Gan 2001
May 27, 2015 at 6:23 pm
meilenb (5/27/2015)
Alan.B (5/27/2015)
Lynn Pettis (5/27/2015)
meilenb (5/27/2015)
Alan.B (5/27/2015)
meilenb (5/24/2015)
...Everyone knows that CO2, CH4 and N2O ...
How is the science clear on climate change when the scientists can't agree? Plus,...
-- Itzik Ben-Gan 2001
May 27, 2015 at 2:52 pm
Lynn Pettis (5/27/2015)
meilenb (5/27/2015)
Alan.B (5/27/2015)
meilenb (5/24/2015)
...Everyone knows that CO2, CH4 and N2O ...
1. It's hard to prove that Everyone knows anything. Statements like "everyone knows" and "we all agree"...
-- Itzik Ben-Gan 2001
May 27, 2015 at 11:57 am
Does the lack of deterministic causality invalidate quantum mechanics?
It Depends.
-- Itzik Ben-Gan 2001
May 27, 2015 at 11:55 am
Michael Meierruth (5/27/2015)
Alan B.How does your function stand up to a varchar(8000) column with an * at the beginning and end and all blanks in between?
Okay, first - both functions...
-- Itzik Ben-Gan 2001
May 27, 2015 at 11:45 am
Emph. mine
meilenb (5/24/2015)
...Everyone knows that CO2, CH4 and N2O ...
1. It's hard to prove that Everyone knows anything. Statements like "everyone knows" and "we all agree" are antithetical to the...
-- Itzik Ben-Gan 2001
May 27, 2015 at 10:21 am
Brandie Tarvin (5/27/2015)
Just curious how many people on The Thread are World Cup fans. Cause... STUFF and MORE STUFF.And I was wondering how y'all felt about it.
I live in Chicago,...
-- Itzik Ben-Gan 2001
May 27, 2015 at 9:52 am
Jeff Moden (5/26/2015)
Alan.B (5/26/2015)
I love this article Jeff and have been using your technique since I discovered this article a little more than a year ago.
Thanks, Alan, but you...
-- Itzik Ben-Gan 2001
May 26, 2015 at 9:18 pm
Viewing 15 posts - 1,441 through 1,455 (of 2,463 total)