Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,376 through 18,390 (of 59,070 total)

RE: Are the posted questions getting worse?

Ed Wagner (2/15/2016)
Jeff Moden (2/12/2016)
Ed Wagner (2/12/2016)
Lynn Pettis (2/12/2016)
Grumpy DBA (2/12/2016)
We will be transitioning to "mountain time". Wake up, breakfast, try to get first chair, snowboard/ski until hungry, grab...
--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)

February 15, 2016 at 8:25 pm

#1858892
RE: QUERY: GET SPACE USED/FREE in All Databases

Orlando Colamatteo (2/15/2016)
It can skip databases: https://www.mssqltips.com/sqlservertip/2201/making-a-more-reliable-and-flexible-spmsforeachdb/
It can be very disruptive. Scary fact: Maintenance Plans used to rely on the proc, may still.
Thanks, Orlando. The good news is that...
--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)

February 15, 2016 at 7:56 pm

#1858890
RE: DBA -tasks and solutions

ramana3327 (2/15/2016)
If you are not using enterprise edition, I think it would be ok with rebuild indexes weekly using maintenance plans
Maintenance plans will rebuild ALL the indexes... even the ones...
--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)

February 15, 2016 at 4:49 pm

#1858877
RE: creating a trigger to update a record

e.hoxholli (2/15/2016)
How can I create a trigger to update rating to rating+1 if audio='choose one format' ?
The database model is located below .
http://imgur.com/cLxTm6K
Looking at the ERD you provided, you need...
--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)

February 15, 2016 at 4:47 pm

#1858876
RE: creating a trigger to update a record

e.hoxholli (2/15/2016)
How can I create a trigger to update rating to rating+1 if audio='choose one format' ?
The database model is located below .
http://imgur.com/cLxTm6K
Have you ever created a trigger before?
--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)

February 15, 2016 at 4:16 pm

#1858872
RE: Migrating SQL Server 2008 to 2012 plus col and date format changes

Michael1 (2/15/2016)
Hello,
I haven't used SQL or SQL server in three years.
I have been charged to do the migration of a 2008 SQL Server database to 2012 SQL Server.
In addition minor...
--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)

February 15, 2016 at 4:10 pm

#1858871
RE: QUERY: GET SPACE USED/FREE in All Databases

Orlando Colamatteo (2/15/2016)
Ramesh Saive (3/6/2009)
There is an undocumented system procedure that executes any T-SQL query in all databases.
EXECUTE sp_MSforeachdb 'EXECUTE sp_spaceused'
Just in case anyone else happens to stumble on this...
--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)

February 15, 2016 at 4:07 pm

#1858870
RE: overlap query where to and from can be same ( of next and previous range)

Thanks, Ben. I appreciate the very kind 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)

February 15, 2016 at 2:39 pm

#1858862
RE: Are the posted questions getting worse?

Sean Lange (2/15/2016)
Grant Fritchey (2/15/2016)
Hugo Kornelis (2/15/2016)
jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before...
--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)

February 15, 2016 at 2:28 pm

#1858858
RE: Are the posted questions getting worse?

jasona.work (2/15/2016)
So, a question for everyone:
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it 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)

February 15, 2016 at 2:24 pm

#1858855
RE: purging old data and outer joins

Sergiy (2/14/2016)
Jeff Moden (2/14/2016)
Sergiy (2/14/2016)
I wonder - how long the SELECT part of the query would take?
The DELETE part would probably take as long as not doing any deletes and...
--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)

February 15, 2016 at 9:32 am

#1858808
RE: Maximum Identity Value Reached

Nope. I'm not 100% sure (and I think the mechanism has changed over the years). I'd do just like you said. I'd have to rig up 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)

February 14, 2016 at 9:33 pm

#1858722
RE: purging old data and outer joins

Sergiy (2/14/2016)
I wonder - how long the SELECT part of the query would take?
The DELETE part would probably take as long as not doing any deletes and would probably delete...
--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)

February 14, 2016 at 8:59 pm

#1858720
RE: Maximum Identity Value Reached

AZ Pete (2/14/2016)
The table is very large - about 250GB.
AZ Pete (2/14/2016)
We are currently in talks with the client to determine if we can delete/archive a large portion of...
--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)

February 14, 2016 at 8:52 pm

#1858719
RE: Maximum Identity Value Reached

Orlando Colamatteo (2/14/2016)
That could also work but will require more downtime. You are somewhat fortunate in this case that the PK is nonclustered.
Perhaps not so fortunate. If the FILL...
--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)

February 14, 2016 at 8:39 pm

#1858716

Viewing 15 posts - 18,376 through 18,390 (of 59,070 total)