Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,516 through 19,530 (of 59,098 total)

RE: Partitioning Table Strategie

ps_vbdev (10/1/2015)
I have a transaction table with 50 million records that's very hard to query. it holds data for the last 4 years but the application only ever looks at...
--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)

October 1, 2015 at 8:37 am

#1830795
RE: How to trim sql query

elmnas (10/1/2015)
I meant I don't want to change any table in the database I just want to collect data and I modify the data.
Then what I said in my original...
--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)

October 1, 2015 at 8:12 am

#1830780
RE: Free form text parsing suggestions

jguffey (9/30/2015)
So I created the tally table and executed your code (thanks for sharing/educating).
[/code]
Make sure that the only column in the Tally Table is NOT NULL and is the PK...
--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)

September 30, 2015 at 3:22 pm

#1830607
RE: Could use some advice

I agree with Erik. It's impossible to keep large or complex plans in your head. You have to write them down and modify the plans when changes occur...
--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)

September 30, 2015 at 7:42 am

#1830434
RE: How to trim sql query

elmnas (9/30/2015)
Hello people I have made following query,
How do I trim my result without replace anything in the current DB?
here is my query
SELECT
tt.bestdatum as 'Year',
FROM
[myDB].dbo.myTable as tt INNER JOIN
WHERE...
--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)

September 30, 2015 at 6:56 am

#1830393
RE: SQL Transition Plan

You really only need to know one thing and that's only if you don't have sysadmin privs on all of the machines. That would be, where are the "SA"...
--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)

September 29, 2015 at 10:45 pm

#1830327
RE: Business is not concerned with HA/DR.

Just curious... how big is the database you're talking about?
--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)

September 29, 2015 at 10:42 pm

#1830325
RE: Backup job & Integrity checks are failing

ramana3327 (9/29/2015)
I am able to create new maintenance plan. But the same error when tried to run that
Based on the given error and as someone suggested previously, who are 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)

September 29, 2015 at 8:58 pm

#1830320
RE: How to avoid using scalar User Defined Functions?

Ah. My apologies, Kim... I missed what you said here...
Kim Crosser (9/29/2015)
Also, that function was a very simplified version of a real one I did years ago, where 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)

September 29, 2015 at 8:24 pm

#1830316
RE: How do I generate test data using only VS 2013?

J Livingston SQL (9/29/2015)
Jeff Moden (9/29/2015)
Start here...
http://www.sqlservercentral.com/articles/Data+Generation/87901/
http://www.sqlservercentral.com/articles/Test+Data/88964/
Hi Jeff.....did you ever do "part 3"
"Coming up in Part 3, random names, characters, codes, and SSNs."
best wishes
I haven't. Got attacked by 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)

September 29, 2015 at 6:11 pm

#1830305
RE: How to avoid using scalar User Defined Functions?

Kim Crosser (9/29/2015)
I think everyone missed the point of the 800,000 records. It isn't that you can save a couple of seconds on an 800,000 record test. 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)

September 29, 2015 at 4:22 pm

#1830298
RE: How do I generate test data using only VS 2013?

Start here...
http://www.sqlservercentral.com/articles/Data+Generation/87901/
http://www.sqlservercentral.com/articles/Test+Data/88964/
--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)

September 29, 2015 at 4:08 pm

#1830295
RE: A Case for Database CI

dg81328 (9/27/2015)
Time after time I have been called only when problems bubbled up to management who made the decision to call-in an experienced person to diagnose "the database problem".
The problem'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)

September 29, 2015 at 4:06 pm

#1830294
RE: Temp Table's Primary Key Default

Ostensibly, the Temp Table has only the required data in it and every row will be used/updated in some fashion. Try NOT having any indexes on the Temp Table...
--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)

September 29, 2015 at 8:07 am

#1830157
RE: Continuous slowness from last 2 week

EasyBoy (9/28/2015)
Yes. User facing the slowness at specific time. They claim that switching tabs takes about 2-3 minutes or when they enter patient information to the application.
Sorry... my comment was...
--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)

September 28, 2015 at 5:21 pm

#1830030

Viewing 15 posts - 19,516 through 19,530 (of 59,098 total)