Forum Replies Created
Viewing 15 posts - 12,766 through 12,780 (of 59,095 total)
-
RE: T-SQL or Standard SQL
icester - Wednesday, March 7, 2018 10:20 AMHello SSC,I am currently reading through "Querying Microsoft SQL Server 2012" (for the 70-461 Exam)....
--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)March 7, 2018 at 11:22 am
-
RE: What non-database skills should a DBA 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)March 7, 2018 at 11:07 am
-
RE: Backups, Backups, Backups.......
jackimo - Friday, January 19, 2018 12:09 PMJeff Moden - Wednesday, January 17, 2018 10:41 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)March 7, 2018 at 10:21 am
RE: Why Haven’t You Upgraded SQL Server?
Thom A - Wednesday, March 7, 2018 7:55 AMJeff Moden - Wednesday, March 7, 2018 7:48 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)March 7, 2018 at 10:12 am
RE: Why does my stored procedure return -1?
junk.mail291276 - Wednesday, March 7, 2018 7:42 AMThanks everyone,Turns out this was causing the return of -1:
SET NOCOUNT ON
If I set NOCOUNT...--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)March 7, 2018 at 7:49 am
RE: Why Haven’t You Upgraded SQL Server?
I still want to know why Mr. Britton has 100,000 instances. 😉
--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)March 7, 2018 at 7:48 am
RE: Create Index Script with Fill Factor Question
ctsufer31 - Tuesday, March 6, 2018 9:05 PMI believe I have found a solution to my issue. There are two articles 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)March 7, 2018 at 7:45 am
RE: Why does my stored procedure return -1?
I'll also add that all those IN (SELECT DISTINCTs are a waste of clock cycles because IN will always stop at the first occurrence of whatever it is you're looking...
--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)March 6, 2018 at 8:03 pm
RE: Create Index Script with Fill Factor Question
Sergiy - Tuesday, March 6, 2018 6:47 PMJeff Moden - Tuesday, March 6, 2018 6:28 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)March 6, 2018 at 7:54 pm
RE: Create Index Script with Fill Factor Question
Sergiy - Tuesday, March 6, 2018 5:39 PMIt does not matter at all.
FIll Factor is only taken into consideration when an 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)March 6, 2018 at 6:28 pm
RE: Help me in designing table and its indexes
RonKyle - Tuesday, March 6, 2018 10:11 AMWhile there's always an exception, I've not yet seen where separation to multiple tables...
--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)March 6, 2018 at 5:44 pm
RE: Help me in designing table and its indexes
Speaking of the OP...
@ SQLAddict01 , your absence from your own request for help is a bit conspicuous. Any feedback 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)March 6, 2018 at 9:44 am
RE: Help me in designing table and its indexes
RonKyle - Tuesday, March 6, 2018 4:25 AMRonKyle - Monday, March 5, 2018 5:06 AMThis...--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)March 6, 2018 at 9:36 am
RE: updates are not happening through ssms
dastagiri16 - Sunday, March 4, 2018 9:12 PMJeff Moden - Sunday, March 4, 2018 12:09 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)March 5, 2018 at 8:36 pm
RE: How does SQL Server handle concurrent operations?
junk.mail291276 - Monday, March 5, 2018 3:10 PMHello everyone,
Thanks for all the replies. Sorry for the late response.
On Friday, I was preparing...--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)March 5, 2018 at 8:34 pm
Viewing 15 posts - 12,766 through 12,780 (of 59,095 total)
