Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,496 through 24,510 (of 59,099 total)

RE: Are the posted questions getting worse?

L' Eomot Inversé (2/3/2014)
Revenant (1/27/2014)
I wish that MSFT introduces a T-SQL construct like this:
RUN ON THREAD a
(some T-SQL)
RUN ON THREAD b
(another T-SQL)
AWAIT a AND b
(runs after both a and b...
--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)

February 3, 2014 at 8:11 am

#1685517
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

davoscollective (2/2/2014)
Wow thanks for what was effectively part 2 in this spackle 🙂 You've written an article in its own right to answer my question and I am very grateful,...
--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)

February 3, 2014 at 8:03 am

#1685513
RE: Query to get the CPU Usage,memory usage details of server

sqlsniper (2/3/2014)
Jeff Moden (2/2/2014)
sqlsniper (2/2/2014)
You could also take a look at Windowstooling, like perfmon and the typeperf tooling.
Perfect! How do you store that in a table in SQL Server?...
--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)

February 3, 2014 at 7:56 am

#1685507
RE: Adding to SQL Server

I'm not sure how many people have a wish list like Peter and I but I'll just bet there's a ton of lurkers going "True dat!". Microsoft should have...
--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)

February 3, 2014 at 7:55 am

#1685506
RE: How to convert char 10/2013 to use the filter >=

Golden_eye (2/3/2014)
Jeff Moden (2/2/2014)
Hmmmm... there IS a way to do this in a SARGable fashion (although fixing the column is still the best idea). I just need to know...
--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)

February 3, 2014 at 7:52 am

#1685503
RE: how to deploy single ssis package in ssis 2012 .

Thanks, Lempster. Seems like all of that makes emergency repairs pretty tough.
--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)

February 3, 2014 at 7:50 am

#1685502
RE: SQL Best practices, policies and code-smells.

David Atkinson (2/3/2014)
Jeff Moden (2/1/2014)
David Atkinson (1/29/2014)
Is anyone actively using any tooling (free or commercial) to help with T-SQL best practices?
WHOSE "Best Practices"?
I guess I meant one's own best practices...
--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)

February 3, 2014 at 7:41 am

#1685496
RE: using count with select case

Absolutely my pleasure. Thanks for posting readily consumable data that actually worked. You made it really easy for me to concentrate on an alternate solution instead of having...
--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)

February 3, 2014 at 7:28 am

#1685492
RE: how to deploy single ssis package in ssis 2012 .

Lempster (2/3/2014)
Koen Verbeeck (2/2/2014)
asranantha (2/2/2014)
Hi friends, in my project having 10 packages with shared connection used.here i need deploy only single ssis package please provide how to solve this issuse...
--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)

February 3, 2014 at 7:25 am

#1685487
RE: how to deploy single ssis package in ssis 2012 .

Koen Verbeeck (2/3/2014)
Jeff Moden (2/2/2014)
Koen Verbeeck (2/2/2014)
asranantha (2/2/2014)
Hi friends, in my project having 10 packages with shared connection used.here i need deploy only single ssis package please provide how to...
--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)

February 3, 2014 at 7:22 am

#1685484
RE: How to convert char 10/2013 to use the filter >=

dwain.c (2/2/2014)
Jeff Moden (2/2/2014)
Hmmmm... there IS a way to do this in a SARGable fashion (although fixing the column is still the best idea). I just need to know...
--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)

February 3, 2014 at 7:10 am

#1685477
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Stuart Davies (2/3/2014)
Excellent article Jeff - and rated as such.
Thanks, Stuart. I appreciate it. Thanks for the read.
--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)

February 3, 2014 at 7:07 am

#1685474
RE: Archiving Data

I have lots of suggestions but "It Depends" on what's what.
1. How many months/GB of data do you want to keep active at any time.
2. What is the format of...
--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)

February 2, 2014 at 10:35 pm

#1685392
RE: MULTI-Instance SQL 2008 R2 Cluster (same LUN can be shared between different Instance?)

Perry Whittle (1/28/2014)
Personally i prefer a dedicated SSRS server and SSIS server (if you do intend to store, manage and run a large amount of packages).
Me too! That way,...
--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)

February 2, 2014 at 10:20 pm

#1685390
RE: Searching all tables for a value, return table name

Google this. "Searching all tables for a value, return table name".
--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)

February 2, 2014 at 10:16 pm

#1685388

Viewing 15 posts - 24,496 through 24,510 (of 59,099 total)