Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,486 through 19,500 (of 59,072 total)

RE: How SQL server fills empty spaces in data files ?

Reindexing will seal up the holes, as well.
--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 9:02 pm

#1830943
RE: First date of the Month (to date on Range basis)

Kristen-173977 (9/28/2015)
Jeff Moden (9/28/2015)
+1000
My new high score :w00t:
FWIW a +1000 pet-hate of mine is using short mnemonics for the datepart parameters e.g. DATEADD(dd, ... instead of DATEADD(Day, ...
I have no...
--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:54 pm

#1830942
RE: New to SQL Server 2014

Searching for "accidental DBA" on Google provides a wealth of information and resources. Here are a couple of good ones.
http://www.johnsansom.com/how-to-become-a-sql-server-dba/
http://www.brentozar.com/archive/2013/07/announcing-our-free-accidental-dba-6-month-training-plan/
http://www.sqlservercentral.com/Books/
--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 7:51 pm

#1830939
RE: Adding zeros into date column

zedtec (10/1/2015)
Hi,
I have a date column (not datetime) in SQL Server and the dates are in the format yyyy-mm-dd
I need to replace the date values with zero's so it looks...
--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:46 am

#1830802
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

Viewing 15 posts - 19,486 through 19,500 (of 59,072 total)