Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,646 through 21,660 (of 59,072 total)

RE: Date logic help

First, don't ever use either a While Loop or a Recursive CTE that counts-up for something like this. Both are horribly slow and it's not a habit you should...
--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)

January 30, 2015 at 11:04 pm

#1774530
RE: Restore from a backup with a wildcard ??

xp_DirTree 'd:path',1,1 will return file names without a trip through xp_CmdShell if all you're looking for is file names.
--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)

January 30, 2015 at 3:16 pm

#1774498
RE: Where do senior SQL DBAs land finally?

You've also picked up on some new lingo. I don't know very many people that haven't actually been in the military that actually knows what "CONUS" means.
--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)

January 30, 2015 at 12:42 pm

#1774457
RE: Deleting 10 million rows from table

Aren't people also adding rows at the same time?
--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)

January 30, 2015 at 11:12 am

#1774425
RE: Where do senior SQL DBAs land finally?

Steve Jones - SSC Editor (1/30/2015)
There is no landing, senior or not. There is only stops along the path of your career.
As you gain experience, and talent, you will 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)

January 30, 2015 at 11:02 am

#1774419
RE: Where do senior SQL DBAs land finally?

S_Kumar_S (1/30/2015)
I don't want to move. NO. I have always loved SQL Server and I still do, absolutely. All I wanted to know if people have done something bigger in...
--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)

January 30, 2015 at 9:00 am

#1774378
RE: Where do senior SQL DBAs land finally?

Heh... agreed. There's a lot to be said for all of that and not suggesting a move. Just suggesting that you'd make a better DBA than a whole...
--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)

January 30, 2015 at 8:46 am

#1774373
RE: Where do senior SQL DBAs land finally?

Sean Lange (1/30/2015)
Jeff Moden (1/29/2015)
Sean Lange (1/29/2015)
Alan.B (1/29/2015)
I am certainly not anywhere at the same DBA skill level as say Jeff, Gail or Sean...
Gosh I am humbled to be grouped...
--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)

January 30, 2015 at 8:23 am

#1774366
RE: Where do senior SQL DBAs land finally?

Sean Lange (1/29/2015)
Alan.B (1/29/2015)
I am certainly not anywhere at the same DBA skill level as say Jeff, Gail or Sean...
Gosh I am humbled to be grouped with those two in...
--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)

January 29, 2015 at 7:55 pm

#1774226
RE: Automating random inserts into a memory optimized table

Paresh Motiwala (1/28/2015)
Hi
I have this table
CREATE TABLE [Sales].[Test_inmem]
(
[c1] [int] NOT NULL,
[c2] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ModifiedDate] [datetime2](7) NOT NULL CONSTRAINT [IMDF_Test_ModifiedDate] DEFAULT (sysdatetime()),
CONSTRAINT [IMPK_Test_SpecialOfferID_ProductID] PRIMARY KEY NONCLUSTERED
(
[c1] ASC
),
INDEX...
--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)

January 29, 2015 at 9:40 am

#1774063
RE: Where do senior SQL DBAs land finally?

S_Kumar_S (1/28/2015)
After having spent some 13 years with SQL Server and being a Sr. DBA for years, today I just thought of having opinion of other Sr. DBA on "Where...
--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)

January 29, 2015 at 9:31 am

#1774055
RE: heap with a lot of unused Space keep growing!

kudz (2/7/2013)
3º The developer has another table(Clustered) with the same data and it's only 120MB and this Heap is spending almost 3GB.
Hold the phone! Why would there be two...
--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)

January 29, 2015 at 8:43 am

#1774037
RE: write a query to get count of all fields named LX where x is a number

fabriziodb (1/29/2015)
for example in a table with this fields "field1, L1,L3,L100" field2 the count is 3
it would be better to match a number into the like but i thinks it...
--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)

January 29, 2015 at 8:34 am

#1774031
RE: Field as Group header

This is a fairly simple adjacency list. The key here will be knowing what the raw data looks like and what the columns Row1 and Row2 are supposed 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)

January 29, 2015 at 8:29 am

#1774030
RE: Are the posted questions getting worse?

GilaMonster (1/29/2015)
Brandie Tarvin (1/29/2015)
GilaMonster (1/29/2015)
Brandie Tarvin (1/29/2015)
Here's one for everyone. Does anyone have an environment where Enterprise is the production edition and Standard is the Dev / Test version?
That's kinda...
--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)

January 29, 2015 at 8:01 am

#1774018

Viewing 15 posts - 21,646 through 21,660 (of 59,072 total)