Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,411 through 16,425 (of 59,101 total)

RE: What's Your Backup Speed?

Nightly restore of 2 main production databases:
DB1: 515GB, 13.35% free space, 10.0GB Log file
DB2: 76GB, 36.69% free space, 33.5GB Log file (yeah... I know)
Total time to restore including...
--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 4, 2016 at 12:05 pm

#1910691
RE: Today's Random Word!

Eirikur Eiriksson (11/4/2016)
crookj (11/4/2016)
Luis Cazares (11/4/2016)
djj (11/4/2016)
Ed Wagner (11/4/2016)
Revenant (11/4/2016)
Hugo Kornelis (11/4/2016)
Luis Cazares (11/4/2016)
Match
Winner
Medal
Olympics
Olympian
Zeus
Orion
The Hunter
Betelgeuse
--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 4, 2016 at 11:57 am

#1910685
RE: Recuperantion des données pour certains dimensions

Luis Cazares (11/4/2016)
Jeff Moden (11/3/2016)
Luis Cazares (11/3/2016)
I believe that you understood correctly, except for the part that the OP needs to get the MDX query instead of T-SQL.
I know it's...
--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 4, 2016 at 11:54 am

#1910683
RE: How to find executed time

With the understanding that it clears out on a restart of the SQL Service, you could also look at sys.dm_db_index_usage_stats. It won't differentiate between INSERTs and UPDATEs but it...
--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 4, 2016 at 8:50 am

#1910616
RE: What's Your Backup Speed?

2.3 TB in an hour and a couple of minutes. On a good night, it takes about 56 minutes. And that's to NAS storage, which is a huge...
--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 4, 2016 at 7:52 am

#1910594
RE: Username increment by 1 if already exists in table

If the number itself is not important, the an easier way to do this might be to add an identity column to the table and create a persisted computed column...
--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 4, 2016 at 7:23 am

#1910581
RE: Maintain statistics on 1 TB Table

Partitioning a table isn't going to help much with stats unless you have 2012 or greater and are willing to accept the default sampling rate, which I'm usually not willing...
--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 4, 2016 at 7:14 am

#1910578
RE: Questions on filetables

I don't know if you've ever read the following but it might give you some hints about why you might not want to drop the Clustered Index prior to loading...
--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 3, 2016 at 9:26 pm

#1910514
RE: Maintain statistics on 1 TB Table

curious_sqldba (11/3/2016)
Folks just wanted to know if anyone has experience maintaining indices and statistics on big tables ( 600 GB +).
Yes, do you have any experience there?
--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 3, 2016 at 8:35 pm

#1910511
RE: way to load db with a lot of constraints

If these tables are of any size, definitely consider loading them with at least the Clustered Index already in place. To do it quickly and without blowing the log...
--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 3, 2016 at 8:31 pm

#1910510
RE: Easy way to search for a string any where within XML column?

I didn't realize that you were trying to shred the XML of packages... certainly not so many of them. I'm no Ninja at XML either and apologize for my...
--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 3, 2016 at 7:43 pm

#1910509
RE: Recuperantion des données pour certains dimensions

Luis Cazares (11/3/2016)
I believe that you understood correctly, except for the part that the OP needs to get the MDX query instead of T-SQL.
I know it's possible but my skills...
--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 3, 2016 at 7:20 pm

#1910508
RE: Easy way to search for a string any where within XML column?

Why not just properly shred the XML and store the results in proper tables? Makes lookups real easy. 😉
--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 3, 2016 at 11:38 am

#1910430
RE: Dynamic pivot and its effect on the plan cache

scott.laird (11/3/2016)
We have a heavily used GUI that displays specific business data in a pivot.
A stored procedure is used to create the pivot, using dynamic SQL.
The SP is using EXEC...
--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 3, 2016 at 11:32 am

#1910428
RE: Generating Our Own Bad Data

Where I work, we actually have to sign off on a monthly notice as to whether or not we are aware of anything "questionable" that could lead to the proverbial...
--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 3, 2016 at 11:09 am

#1910423

Viewing 15 posts - 16,411 through 16,425 (of 59,101 total)