Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,171 through 19,185 (of 59,098 total)

RE: Table Paritioning

Welsh Corgi (11/9/2015)
Jeff Moden (11/9/2015)
Welsh Corgi (11/9/2015)
I have written a Stored Procedure to Archive Tables.
I have been asked to Partition the tables.
Would I be better off to hold off on...
--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)

November 17, 2015 at 7:34 pm

#1840515
RE: Rebuilding large index with limited free space

ricardo_chicas (11/9/2015)
Thanks
I will do something similar, add a new file group and move those tables over there
What is the table used for? For example, is it an audit or...
--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)

November 17, 2015 at 7:17 pm

#1840514
RE: Querying Oracle via Linked Server crashes SQL Server

Gordon Feeney (11/17/2015)
Was just about to raise a call with MS support when I came across a possible solution on their support site. I tested the fix and it works....
--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)

November 17, 2015 at 7:11 pm

#1840513
RE: SSIS - CSV Row being dropped

Disclaimer: I am NOT an SSIS user. I do this type of stuff using T-SQL and I'm not even sure that I know how to even spell "SSIS"....
--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)

November 17, 2015 at 7:02 pm

#1840512
RE: Key Value Pair Table

yb751 (11/11/2015)
Well I just finished talking with our Dev team and I realized that the attributes do not need to be updated individually. Also any searches would be offloaded...
--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)

November 17, 2015 at 6:25 pm

#1840510
RE: Question for All DBAs (What can I learn to enahnce my career?)

MadAdmin (11/10/2015)
Favorite Quotes:
"Has anyone ever told you that a query you have written runs too fast?" - Dwain Camps - 6 Mar 2014
Yes.
Because the DB was then able to successfully...
--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)

November 17, 2015 at 5:32 pm

#1840508
RE: SQL Credentials password reset

If it's an AD account, you shouldn't have to do anything with "SQL Credentials" that already exist. If by "SQL Credentials", you mean an SQL Login rather than a...
--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)

November 17, 2015 at 5:29 pm

#1840506
RE: Adding ndf files to tempdb and shrinking the mdf

S_Kumar_S (11/17/2015)
Hi
I have a tempdb with 130 GB mdf and 6 GB ldf file size. Now because of PAGEIOLATCH_XX wait types, I have to a make the number 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)

November 17, 2015 at 5:23 pm

#1840505
RE: Performance impact of self-referencing Linked Server

keymoo (11/17/2015)
I am going through a consolidation exercise where I want to put databases from one instance into another existing instance. Currently the instances are on separate hardware.
So SERVER1\INSTANCE_A has...
--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)

November 17, 2015 at 5:19 pm

#1840504
RE: A Case FOR Cursors...

Hugo Kornelis (11/17/2015)
I have never found or seen a method for computing running (pre SQL Server 2012) that has comparable performance to a well-programmed cursor solution, except for the methods...
--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)

November 17, 2015 at 4:39 pm

#1840502
RE: Are the posted questions getting worse?

Lynn Pettis (11/17/2015)
OMG
Unfortunately, WTC (Way Too Common). Gail has got to be getting tired of suppressing a literal "Dear Stupid" response.
--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)

November 17, 2015 at 4:34 pm

#1840501
RE: Unable to print the charindex of a special character of its 4th occurrence.

SQL-DBA-01 (11/17/2015)
Hello,
I am unable to get the 3rd and 4th occurrence of the "_" using charindex. Can anyone please suggest?
Can bring 1st and 2nd occurence position.
example string:
AB_CD_EF_GH_IJ
SELECT CHARINDEX('_', name) a_First_occurence,
CHARINDEX('_',...
--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)

November 17, 2015 at 12:20 pm

#1840466
RE: upload and store TIF (Image) files into a SQL Server Database

After some recent experiences, I have to strongly agree with what Donald wrote above.
I have a phone system where the original programmers stored the recorded calls (similar to storing...
--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)

November 17, 2015 at 8:28 am

#1840362
RE: Referencing function from another database in CREATE TABLE stmt

SoHelpMeCodd (11/17/2015)
It may be worthwhile to think about a disaster scenario: If the utilities database goes offline, how many databases will be impacted?
Eggsactly (pun intended inferring "all eggs in one...
--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)

November 17, 2015 at 8:10 am

#1840345
RE: Are the posted questions getting worse?

WayneS (11/17/2015)
Ed Wagner (11/16/2015)
WayneS (11/16/2015)
Lynn Pettis (11/13/2015)
(think government contracted software development).
My scary story when working with the gov't.
Software contract awarded, specified that all data access has to go through stored...
--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)

November 17, 2015 at 7:54 am

#1840337

Viewing 15 posts - 19,171 through 19,185 (of 59,098 total)