Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,681 through 13,695 (of 59,101 total)

RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

SQL-DBA-01 - Sunday, November 19, 2017 11:34 AM
Eirikur Eiriksson - Sunday, November 19, 2017 11:05 AM
--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 19, 2017 at 12:20 pm

#1968688
RE: VARBINARY(n) vs VARBINARY(MAX) - size

DamianC - Saturday, November 18, 2017 9:52 AM
Hello
I haven't really had the need for VARBINARY before
Just started filling in some gaps 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)

November 19, 2017 at 9:58 am

#1968680
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

SQL-DBA-01 - Friday, November 17, 2017 1:29 PM
ZZartin - Friday, November 17, 2017 1:17 PM
--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 19, 2017 at 9:42 am

#1968679
RE: Are the posted questions getting worse?

Grant Fritchey - Sunday, November 19, 2017 6:46 AM
WayneS - Friday, November 17, 2017 3:44 PM
--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 19, 2017 at 9:31 am

#1968677
RE: Extracting a specific number of words from a string in sql

chinhvowili - Sunday, November 19, 2017 12:01 AM
Adam Haines - Wednesday, February 27, 2008 7:32 AM
--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 19, 2017 at 9:06 am

#1968676
RE: One of my sql database

yetiger909 - Sunday, November 19, 2017 3:32 AM
If you canâ€™t open or repair .mdf via any method, in such case was...
--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 19, 2017 at 8:59 am

#1968675
RE: Automatic Plan Correction

As always, great article with working examples! Thanks for taking the time to post it Wayne.
--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 18, 2017 at 7:06 pm

#1968657
RE: Creating a PDF from a Stored Procedure

jairamkumar01 - Friday, November 17, 2017 11:07 PM
There are following requirement:
1- Text Formatting in some place like bold , underline
2- Some dynamic data...
--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 18, 2017 at 9:47 am

#1968644
RE: 0 or $0.00 instead of NULL?

Jason A. Long - Friday, November 17, 2017 8:02 PM
Jeff Moden - Friday, November 17, 2017 5:47...
--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, 2017 at 9:08 pm

#1968625
RE: Query to find what current query the procedure is executing.

adilahmed1989 - Friday, November 17, 2017 3:25 AM
Dear All,
Have a job on a server in which it executes a stored procedure that...
--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, 2017 at 5:52 pm

#1968620
RE: 0 or $0.00 instead of NULL?

chef423 - Friday, November 17, 2017 10:22 AM
Thom A - Friday, November 17, 2017 10:05 AM
--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, 2017 at 5:47 pm

#1968619
RE: One of my sql database

Heh... I've seen this post before. Stand by for the SPAM folks. 😉
--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, 2017 at 5:24 pm

#1968616
RE: Auto Generate Your Database Documentation

Andy Jones, DBA - Friday, November 17, 2017 3:52 PM
Jeff Moden - Friday, November 17, 2017 8:18...
--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, 2017 at 5:23 pm

#1968615
RE: Start Fixing Your DB with Better Code

Eric M Russell - Friday, November 17, 2017 8:13 AM
Jeff Moden - Friday, November 17, 2017 7:46...
--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, 2017 at 8:27 am

#1968536
RE: Auto Generate Your Database Documentation

The code for the auto-generation of extended properties in this article seems to be just a regurgitation of properties that should be listed elsewhere. It doesn't explain the purpose of the...
--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, 2017 at 8:18 am

#1968532

Viewing 15 posts - 13,681 through 13,695 (of 59,101 total)