Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,676 through 21,690 (of 59,098 total)

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
RE: Lead/Lag Functions

bjames60689 (1/28/2015)
I agree with everything said. Unfortunately I am working within a system that i do not have control of changing.
The reason for the post was to find out...
--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 28, 2015 at 4:32 pm

#1773849
RE: Parsing data to from a field into a new record of a different table

My pleasure and welcome back!
--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 28, 2015 at 4:28 pm

#1773848
RE: Lead/Lag Functions

bjames60689 (1/28/2015)
I understand what you are saying. Do you feel the same way when it is more exact, such as millisecond (2000-06-11 23:59:59.990)?
Basically I want to make it so...
--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 28, 2015 at 3:52 pm

#1773844
RE: Parsing data to from a field into a new record of a different table

See the following for how to use CrossTabs and Pivots.
http://www.sqlservercentral.com/articles/T-SQL/63681/
See the following for how to make the CrossTabs dynamic.
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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 28, 2015 at 3:34 pm

#1773836

Viewing 15 posts - 21,676 through 21,690 (of 59,098 total)