Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,266 through 20,280 (of 59,098 total)

RE: Big Data Engineers

Heh... there is no such thing as "Big Data". There's only 2 categories of data insofar as size... 1) that which you can handle and 2) that which you...
--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)

June 23, 2015 at 7:21 pm

#1807607
RE: server automatically reboots after windows updates

karend211 34657 (6/23/2015)
Hi there,
The database server is rebooting at various times automatically after a windows update. Our admin people are telling me this is ok and that sql is...
--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)

June 23, 2015 at 7:04 pm

#1807605
RE: Compare field to results from another table

For starters, there is likely no need for the OUTER join if you're using WHERE NOT IN.
--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)

June 23, 2015 at 6:42 pm

#1807600
RE: Partition an existing SQL Server Table

Welsh Corgi (6/23/2015)
Jeff Moden (6/23/2015)
Yep... Saw that. You'd be better off partitioning by year.
He wants to partition 15 years into the First Partition and the current year in another...
--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)

June 23, 2015 at 6:36 pm

#1807598
RE: Is is possible to Dynamic join on EXECUTE table column

In that case, something like your original query could work if the EXEC were encapsulated in OPENROWSET or maybe even the less priv hungry OPENDATASOURCE. The OPENDATASOURCE method might...
--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)

June 23, 2015 at 4:27 pm

#1807592
RE: Skill Supply and Demand

TomThomson (6/23/2015)
If that had happened on a large scale we would still be using hierarchic and network databases not relational.
Heh... it did happen on a large scale and we...
--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)

June 23, 2015 at 3:28 pm

#1807583
RE: How to put data from sql SERVER to notepad using t-sql

Steve Jones - SSC Editor (6/23/2015)
bcp isn't in the path on the server. The server service account (or xp_cmdshell proxy) is calling bcp, but can't find it.
Get the path on...
--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)

June 23, 2015 at 3:14 pm

#1807577
RE: Is is possible to Dynamic join on EXECUTE table column

Sean Lange (6/23/2015)
pjn (6/23/2015)
seriously? any need for that?
I asked a question, I accepted it, its fine, I wanted to know it something could be done (as in initial question), 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)

June 23, 2015 at 3:06 pm

#1807573
RE: Are the posted questions getting worse?

I think he's just experimenting and hasn't told anyone.
--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)

June 23, 2015 at 12:00 pm

#1807511
RE: Is is possible to Dynamic join on EXECUTE table column

Sean Lange (6/23/2015)
pjn (6/23/2015)
Not sure? if this is ever going to be possible, but I'm trying to do a dynamic join on EXECUTE, but the execution string has to come...
--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)

June 23, 2015 at 11:59 am

#1807510
RE: Hidden RBAR: Counting with Recursive CTE's

j-1064772 (6/23/2015)
[font="Comic Sans MS"]Ah but that was a MIXTURE, not pure water. Even CO₂ dissolved in water is a mixture.
And for an amazing development, check out NITINOL - a shape...
--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)

June 23, 2015 at 11:56 am

#1807509
RE: Hidden RBAR: Counting with Recursive CTE's

I've actually had the phenomena occur in my truck overnight in the winter months both with bottled spring water and Pepsi. It's amazing how cold it was (~10^o-15^oF) 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)

June 23, 2015 at 9:00 am

#1807421
RE: Trying to use T-SQL to calculate elapsed time

cstg85 (6/23/2015)
Jeff,
Your post couldn't have come in a more timely manner, the time calculation is actually apart of a bigger query which in fact returned the error you mentioned....
--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)

June 23, 2015 at 8:46 am

#1807410
RE: Audit administrative logins

True enough but if SQL Server can see the file, so can the DBA... and he doesn't even need to use xp_CmdShell to do it. When I say "see"...
--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)

June 23, 2015 at 8:17 am

#1807383
RE: Partition an existing SQL Server Table

Yep... Saw that. You'd be better off partitioning by year.
--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)

June 23, 2015 at 8:15 am

#1807380

Viewing 15 posts - 20,266 through 20,280 (of 59,098 total)