Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,421 through 30,435 (of 59,101 total)

RE: Count Data in Large Seprated Text

dwain.c (4/8/2012)
It turns out this will be extensible to when you, despite others recommendations to not do this, you extend your strings to contain other values besides City and Country....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2012 at 6:56 am

#1470625
RE: TSQL TestBits function for rapidly testing multiple switch settings

I don't know why someone rated this as a "3" at the start. It's a good primer on Boolean Logic even if someone doesn't use the function. Nicely...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2012 at 6:48 am

#1470619
RE: How to you use dbmail with BCP

Thanks for the feedback, Nitin. Let me know how it all works out. Thanks.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2012 at 6:36 am

#1470616
RE: How reliable execuion plan estimates are!!

S_Kumar_S (4/9/2012)
Well , I understand that Estimated execution plan might be giving just "estimates" but actual execution plans should have more accuracy.
In my question, I was referring to atual execution...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2012 at 6:20 am

#1470612
RE: Question on Pitvoting data in SQL

Sean Lange (4/5/2012)
Unless the product list is going to exceed 8,000 characters there is no need to use CLR for this. The code I provided is a delimited list with...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 9, 2012 at 6:11 am

#1470607
RE: Count Data in Large Seprated Text

True enough, Dwain.:-) I was more concerned about the OP's bad split function than anything else.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2012 at 10:00 pm

#1470570
RE: Strange Tables In TempDB

SQL Server creates a lot of Temp Tables to handle queries for the system and other things. They all look like # followed by some number. I wouldn't...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2012 at 9:55 pm

#1470569
RE: Modified DateTimeStamp - No Default on record creation

I prefer they both be NOT NULL and, like Gail identified, will make both the same on INSERT. I also use a trigger to enforce updates to the MODIFIED_DATE...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2012 at 9:49 pm

#1470567
RE: Teach myself SSIS

~~Now that that's settled, what would you have done in SSIS if you could have used it?~~
Sorry... didn't see the title of this thread which explains that.
My recommendation would be...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2012 at 5:19 pm

#1470548
RE: SQL JOBS

If you want to disable ALL jobs quickly and easily, just turn off SQL Agent.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2012 at 3:00 pm

#1470541
RE: How to you use dbmail with BCP

First, a disclaimer. I've done a lot of things similar to the following but I've not actually included the output as an attached file to an email. I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2012 at 11:52 am

#1470534
RE: Count Data in Large Seprated Text

ahmedhussein787 (4/8/2012)
OK do you have any alternative ??
The "alternative" high performance splitter code is attached to the end of that article in the "resources" section.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 8, 2012 at 7:01 am

#1470519
RE: How to you use dbmail with BCP

nitinuniyal (4/3/2012)
[font="Tahoma"]Thanks for the Reply..
But what i want is to mail the results in Excel format, if I only define the SP in query then it will only give me...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 7, 2012 at 4:18 pm

#1470484
RE: How to identify query causing huge drop in Page Life Expectancy

Perry Whittle (4/7/2012)
Jeff Moden (4/7/2012)
check the scheduled jobs and see what's happening around that time frame.
Great minds think alike 🙂 😉
Perry Whittle (4/7/2012)
I'd start by runnuning through and verifying any...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 7, 2012 at 1:12 pm

#1470442
RE: Count Data in Large Seprated Text

ahmedhussein787 (4/7/2012)
Split Function Code
USE [Test]
GO
/****** Object: UserDefinedFunction [dbo].[Split] Script Date: 04/07/2012 19:03:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[Split](@String varchar(8000), @Delimiter...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 7, 2012 at 1:06 pm

#1470441

Viewing 15 posts - 30,421 through 30,435 (of 59,101 total)