Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,381 through 16,395 (of 59,067 total)

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
RE: CREATE TABLE and Indexes

The question now is, did they update the script generator to reflect this new capability? Probably not. I also think it's interesting that they'd spend time on such...
--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:04 am

#1910358
RE: Drill down values...

PiMané (11/3/2016)
Is it possible to get the total orders from a customer and drill down to the supplier in the same query?
Yes. You can use GROUP BY WITH ROLLUP...
--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:33 am

#1910344
RE: Delete files that are older than 7 days

Deny Christian (11/2/2016)
Jeff Moden (11/2/2016)
Deny Christian (11/1/2016)
else,
i used this syntax
DECLARE @CMD sysname
--create .bat:
/*.bat:
@echo off
forfiles /p "d:\backup\bck_denyc\combine" /m *.bak /c "cmd /c del /Q @file" /d -30 --to delete 30...
--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:08 am

#1910338
RE: Include the first zero when converting time from datime into INT

hoseam (11/2/2016)
Both Date and Time are stored as INT datatypes in my Dimensions, hence I needed to convert them to INT values.
I understand that and THAT's what I'm saying is...
--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:06 am

#1910337

Viewing 15 posts - 16,381 through 16,395 (of 59,067 total)