Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,226 through 15,240 (of 59,101 total)

RE: SQL Help - How do I get a list of all the DB names in the server and a list of SCHEMAS that belong to each DB

I'm a little bit old fashioned... and a bit of a control freak when it comes to such things, not to mention being a bit anal about formatting and readability...
--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)

April 8, 2017 at 8:48 pm

#1937334
RE: creating objects in master or msdb database

A better practice would be to create a small "utility" database for such things.
To be honest, though... you don't need a separate table to do comparisons with. Jobs...
--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)

April 8, 2017 at 6:55 pm

#1937332
RE: Increase Disk Space on Data Drive

stephen.godwin - Friday, April 7, 2017 12:10 PM
As is common, I inherited this mess. The test server is almost complete, i just...
--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)

April 8, 2017 at 6:42 pm

#1937331
RE: Good Referrence For Evaluate SQL Server vs Oracle

IMHO, there is no totally reliable, unbiased, completely accurate comparison except possibly for the cost of ownership.
There are a lot of folks that will say that MS has created...
--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)

April 8, 2017 at 4:20 pm

#1937329
RE: Calculate Easter Date

First, yes... I'm aware that the original script for this thread came out over 9 years ago. It is, however, a timeless problem and there is a rather serious optimization...
--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)

April 8, 2017 at 3:47 pm

#1937327
RE: Calculate Easter Date

tthu1501 - Friday, April 7, 2017 9:37 PM
we can calculate easter date without sql data like this When Is Easter...
--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)

April 8, 2017 at 10:17 am

#1937317
RE: Help in finding actual days and hours difference!!!

Sergiy - Friday, April 7, 2017 10:17 PM
dhanekulakalyan - Friday, April 7, 2017 9:35 AM
--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)

April 8, 2017 at 9:49 am

#1937315
RE: Running Total

Ok. Here's a test data generator for folks to play with. I normally use a million rows just to get some clue as to how scalable whatever code is being...
--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)

April 7, 2017 at 11:48 pm

#1937305
RE: Running Total

Luis Cazares - Friday, April 7, 2017 8:27 PM
robertopmorris - Friday, April 7, 2017 2:04 PM
--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)

April 7, 2017 at 10:33 pm

#1937304
RE: Retrieving Maximum and Minimum Timestamp of a certain day from a set of timestamps [SOLVED]

joao.neto_87 - Friday, April 7, 2017 7:52 AM
@thom-2 A
That works great, but I can't have manually input values into the SQL.
The timestamps...
--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)

April 7, 2017 at 9:15 am

#1937225
RE: Increase Disk Space on Data Drive

stephen.godwin - Friday, April 7, 2017 1:14 AM
Its a virtual server, so that sorted. Backups are performed , just our developers keep...
--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)

April 7, 2017 at 8:28 am

#1937217
RE: Index and or constraint

gvoshol 73146 - Friday, April 7, 2017 5:13 AM
Jeff Moden - Thursday, April 6, 2017 5:10 PM
--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)

April 7, 2017 at 7:06 am

#1937201
RE: Running Total

robertopmorris - Friday, April 7, 2017 1:47 AM
You're SQL code works and I achieve the Running Total per line - however...
--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)

April 7, 2017 at 7:04 am

#1937200
RE: Running Total

Joe Torre - Thursday, April 6, 2017 4:45 PM
Sorry, missed that:
This works in 2008:

IF Object_Id(N'tempdb.dbo.#mytable','U') IS NOT NULL
DROP 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)

April 6, 2017 at 7:54 pm

#1937166
RE: Index and or constraint

gvoshol 73146 - Thursday, April 6, 2017 5:39 AM
Jeff Moden - Wednesday, April 5, 2017 4:54 PM
--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)

April 6, 2017 at 5:10 pm

#1937163

Viewing 15 posts - 15,226 through 15,240 (of 59,101 total)