Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,721 through 21,735 (of 59,098 total)

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
RE: ID or Id

RonKyle (1/24/2015)
What are the issues with DATETIME2 and DATEDIFF?
Simple. Given a single row that contains StartDate and EndDate columns as DATETIME2 columns, write the code to calculate the duration...
--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:53 am

#1772913
RE: Please explain what this Trigger query does

Let's answer the questions in the reverse order of your posts.
lawlietdba (1/24/2015)
Hi Jeff,
Please spare me, im asking same doubt again, :unsure:
Im doing the testing of the new trigger without...
--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:41 am

#1772911
RE: Please explain what this Trigger query does

lawlietdba (1/24/2015)
Hi Jeff,
Sorry for the late reply, I took some time to find out things you asked...
I also come up with doubts regarding the things you said,
Please spare me...
--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:35 am

#1772892
RE: HTML stored in a varchar max column being truncated, how do I return it?

Ugh! Understood.
Are you, by any chance, defining a tag as <a>, <col>, or <del>somewhere in the mix? Or maybe there's an "unclosed" tag somewhere? Other than 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)

January 24, 2015 at 12:26 am

#1772884

Viewing 15 posts - 21,721 through 21,735 (of 59,098 total)