Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,151 through 24,165 (of 59,099 total)

RE: Architecture and Management Question - Multiple Schemas and Tables Vs Few Tables with Thousands of Rows

JoshDBGuy (3/14/2014)
Jeff Moden (3/14/2014)
JoshDBGuy (3/14/2014)
I will be working on a plan to import data from multiple sources (say about 1000 sources). These sources will have different data, however, the actual...
--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)

March 14, 2014 at 1:48 pm

#1697295
RE: Need help in table design

To be honest, you shouldn't need an "OverPayments" table. My recommendation would be to hire a local pro to design your database(s) and the entities therein. If 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)

March 14, 2014 at 1:09 pm

#1697275
RE: Viewing Partition tables data

To be honest, you shouldn't need to even know the table is partitioned if it's done correctly. The partitioning column, function, and schema should do it all auto-magically.
--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)

March 14, 2014 at 1:03 pm

#1697272
RE: TEMPDB on RAM

Admingod (3/14/2014)
Configuring SQL to put TEMPDB completely on RAM? .If RAM is dedicate to TempDB will improve performance?
Thanks
To be honest, this is a bit like putting a bandaid on a...
--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)

March 14, 2014 at 12:58 pm

#1697268
RE: Architecture and Management Question - Multiple Schemas and Tables Vs Few Tables with Thousands of Rows

JoshDBGuy (3/14/2014)
I will be working on a plan to import data from multiple sources (say about 1000 sources). These sources will have different data, however, the actual table layouts for...
--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)

March 14, 2014 at 8:43 am

#1697163
RE: Transaction Log and TempDB Calculations

alex.sqldba (3/13/2014)
Evening All,
Is there a formula for calculating how expensive a transaction will be in terms of disk space used before its run. I dont want it accurate to the...
--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)

March 14, 2014 at 12:17 am

#1697033
RE: SSIS Data Flow "bulk insert" VS. INSERT INTO

below86 (3/13/2014)
We are currently pulling in 1+million rows of data for a monthly process, all records processed in the prior month. This data is coming from others sources like...
--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)

March 13, 2014 at 5:10 pm

#1696996
RE: Cross Apply --reducing the number of combinations

rhmohamed (3/13/2014)
Hi,
I have issue with ny cross apply.I'm currently using to combine values from 2 fields.
example:
fields A = 1,2,3
fields B = X,Z
using the cross apply give me that results :
1,X
1,Z
2,X
2,Z
3,X
3,Z
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)

March 13, 2014 at 4:55 pm

#1696990
RE: Would Bulk Insert Help??

david.ostrander (2/27/2014)
In the SSIS package I have a Select Statement to query the SQL Server (A)
How many rows does it select at one time? Better yet, can you post the...
--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)

March 13, 2014 at 4:51 pm

#1696989
RE: Are the posted questions getting worse?

Wow! I just looked at the submitted session list for SQL Saturday 292 here in Detroit. The "Call for Speakers" closes on 3/18 (just 5 days from now)...
--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)

March 13, 2014 at 3:47 pm

#1696978
RE: How can i pivot this code?

You bet. Thank you for the feedback.
--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)

March 13, 2014 at 3:20 pm

#1696966
RE: Insert Statement for 2 million rows

Eric M Russell (3/13/2014)
pretea (3/13/2014)
Hi!
I have multiple (individual) insert statement to insert around 2 million rows (using sqlcmd because the insert stament is around 8 thou lines).
It took about an...
--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)

March 13, 2014 at 12:02 pm

#1696916
RE: How can i pivot this code?

simflex-897410 (3/13/2014)
Thanks Jeff,
My fault. My reasoning was that our production server hosts sql server 2008.
So, I figured it is better to have a sql server 2008 solution than 2005 because...
--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)

March 13, 2014 at 11:23 am

#1696896
RE: help with a instead of trigger

gfoulks (3/13/2014)
Jeff all valid points. The ssn right now is last four and the plan is to go to a hashed number right now the table is in the proof...
--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)

March 13, 2014 at 11:16 am

#1696890
RE: Assistance with Partition-level locking and X lock on UPDSTATS

jack.odom 35193 (3/13/2014)
Thanks for the reply Jeff. I've updated the data set to more accurately simulate the data I'm actually using, and you are correct that I am not getting...
--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)

March 13, 2014 at 11:14 am

#1696888

Viewing 15 posts - 24,151 through 24,165 (of 59,099 total)