Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,916 through 9,930 (of 59,093 total)

RE: Stop rolling back transaction

SQL_Hunt - Tuesday, January 29, 2019 5:18 PM
Hello, I want to delete records from multiple records (very old records and does not...
--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, 2019 at 6:56 pm

#2020497
RE: Purpose of SELECT before a calcuating the value of a function's return variable

michael.leach2015 - Tuesday, January 29, 2019 6:05 PM
In the code below what is the purpose of the SELECT statement before @SalesTaxDue...
--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, 2019 at 6:53 pm

#2020496
RE: Doing the Right Thing

patrickmcginnis59 10839 - Tuesday, January 29, 2019 10:10 AM
Jeff Moden - Tuesday, January 29, 2019 9:07 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)

January 29, 2019 at 10:12 am

#2020457
RE: Doing the Right Thing

patrickmcginnis59 10839 - Tuesday, January 29, 2019 8:10 AM
Jeff Moden - Tuesday, January 29, 2019 7:09 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)

January 29, 2019 at 9:07 am

#2020431
RE: storing Image in Database (SQL Server ) vs File System

To be absolutely honest and, hopefully, a bit more clear (I DO use DBCC CHECKDB but not in production and I don't time it) , nothing is a full up substitute...
--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, 2019 at 8:27 am

#2020420
RE: Doing the Right Thing

patrickmcginnis59 10839 - Monday, January 28, 2019 12:57 PM
Jeff Moden - Monday, January 28, 2019 9:30 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)

January 29, 2019 at 7:09 am

#2020403
RE: Dynamically outputting a set of columns based on another Tables records

Thom A - Monday, January 28, 2019 4:47 AM
Weegee2017 - Monday, January 28, 2019 4:31 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)

January 29, 2019 at 6:08 am

#2020391
RE: Today's Random Word!

Ed Wagner - Monday, January 28, 2019 11:28 AM
TomThomson - Saturday, January 26, 2019 4:49 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)

January 28, 2019 at 12:49 pm

#2020322
RE: storing Image in Database (SQL Server ) vs File System

An example of the above... I ran DBCC CHECKDB WITH ESTIMATEONLY on one of my databases that has no "images" stored. The MDF file is only 900GB and there's 150GB...
--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, 2019 at 12:16 pm

#2020321
RE: storing Image in Database (SQL Server ) vs File System

Ken McKelvey - Monday, January 28, 2019 10:16 AM
Thanks for this detailed post; it could affect how we design something later...
--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, 2019 at 12:00 pm

#2020319
RE: trying to learn SQL development

deep1 - Sunday, January 27, 2019 11:24 PM
can some one help me learn by asking some questions on query building basically tasks....
--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, 2019 at 10:17 am

#2020311
RE: Doing the Right Thing

Geoff.Sturdy - Monday, January 28, 2019 8:21 AM
So what did I learn today from this post ? absolutely nothing about SQL server...
--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, 2019 at 9:30 am

#2020298
RE: very slow select

Tomys - Tuesday, January 22, 2019 9:23 AM
Dear sir, I am not sure if this proper for the columns you mentioned...
--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 27, 2019 at 7:24 pm

#2020237
RE: very slow select

Jonathan AC Roberts - Tuesday, January 22, 2019 9:50 AM
Tomys - Tuesday, January 22, 2019 9:23 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)

January 27, 2019 at 7:11 pm

#2020235
RE: Query tuning with conditional aggregation

We're just guess here. Please post the full DDL for the Exampledb.dbo.SourceTable_EF278 table including all constraints and indexes.
It would also be helpful if you if you provided some...
--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 27, 2019 at 2:43 pm

#2020231

Viewing 15 posts - 9,916 through 9,930 (of 59,093 total)