Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,691 through 21,705 (of 59,072 total)

RE: Help needed in Performance Tuning

First, thank you for taking the time to build the test data. That will really help.
It would be helpful if, instead of trying to figure out what the overall...
--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 25, 2015 at 10:30 am

#1772957
RE: Query result display layout

kd11 (1/25/2015)
Question, I have a query I select the data from it will return the data as such:
ManagerName EmployeeName HoursWork
John...
--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 25, 2015 at 10:13 am

#1772955
RE: Please explain what this Trigger query does

You bet and thank you for the great questions and feedback throughout this thread. Let us know how it all works out when you get the chance.
--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 25, 2015 at 9:39 am

#1772951
RE: Selecting and merging records for a singular complete record

k.allen.emt (1/24/2015)
I have a database full of different types of leads some for company A some for company B and so on, each doing a different service. However the leads...
--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 24, 2015 at 9:29 pm

#1772937
RE: Re-Indexed with the Wrong Fill Factor and Now All Databases Are Huge

Crud. Almost forgot... I know it sounds a little weird but, even though the shrink will make a fragmented train wreck out of the database, consider doing the reindexes...
--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 24, 2015 at 9:18 pm

#1772936
RE: Re-Indexed with the Wrong Fill Factor and Now All Databases Are Huge

Once you shrink the database, as pietlinden says, you'll need to rebuild all indexes. Despite how good many of the index routines written by various people are, a lot...
--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 24, 2015 at 9:14 pm

#1772934
RE: Table structure for creating timetable for a school

Nah. Done correctly, audit triggers are fast and a breeze to write. It also depends a bit on whether you're doing "whole row" auditing or "column level" auditing,...
--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 24, 2015 at 8:54 pm

#1772933
RE: What's the best practices for storing Very Large Tables?

I've never worked with Azure but, according to the following article...
https://msdn.microsoft.com/en-us/library/azure/hh508997.aspx
... it looks like you'll need to recombine the individual tables to take advantage of partitioning and you should absolutely...
--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 24, 2015 at 8:39 pm

#1772931
RE: Filter on profiler

sm_iransoftware (1/24/2015)
Hi
we are on emergency state.
Application is very slow and some times give time out.
in Database , which thing Should I examin in first step?
and then :...
--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 24, 2015 at 5:06 pm

#1772925
RE: What's the best practices for storing Very Large Tables?

Rahuul (1/24/2015)
Hi,
We are in the middle of re-designing few tables (namely transaction tables) that would store very large data and would be hosted on cloud (Azure). The old design 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)

January 24, 2015 at 4:03 pm

#1772923
RE: Which Problem Are You Solving?

Steve Jones - SSC Editor (1/24/2015)
Comments posted to this topic are about the item <A HREF="/articles/Editorial/121702/">Which Problem Are You Solving?</A>
Since 90% of any effective solution is the correct identification 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)

January 24, 2015 at 3:35 pm

#1772922
RE: Deploy the Database First

I agree. It's like Developers and DBAs. I don't know why people treat them separately. They should be on the same team with the same goals. ...
--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 24, 2015 at 3:14 pm

#1772921
RE: SQL SERVER + SSD

Bunny786 (1/22/2015)
Thanks a lot for reply.
SQL Server not Shutting down or not crashing ,We have 15-20 developers to access the 30 TB database,Some of the developers are able to connect...
--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 24, 2015 at 3:09 pm

#1772920
RE: Please explain what this Trigger query does

Correct. Inserts never go into the audit table. Only the changes from UPDATEs and DELETEs. If a row is Inserted into the Employee table, and is never...
--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 24, 2015 at 2:53 pm

#1772919
RE: ID or Id

Eric M Russell (1/24/2015)
I am thankful for introduction of the short Date and have made heavy use of it last few years.
Yes. I agree with that 100%. But...
--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 24, 2015 at 10:57 am

#1772914

Viewing 15 posts - 21,691 through 21,705 (of 59,072 total)