Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,281 through 20,295 (of 59,072 total)

RE: Audit administrative logins

Virtually anything and everything that can be done on SQL Server can be undone or sidestepped by anyone having or breaking into the server with sysadmin privs on SQL Server.
I...
--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 21, 2015 at 10:02 am

#1806903
RE: Error using "Update" and "Set" commands

Sandy,
There's a ton of danger in joined updates unless things are done just right and I see a couple of possible "newbie" problems in your examples. Some of these...
--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 21, 2015 at 9:47 am

#1806902
RE: Help in query

Sean Lange (6/19/2015)
Storing integers as floats is crazy. :w00t:
BWAA-HAA!!!! Storing date info in INTs is almost as crazy! 😀
--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 19, 2015 at 9:37 am

#1806744
RE: Need Ammunition for Developers Doing Select *'s

Michael L John (6/19/2015)
The unfortunate part is that it's sometimes very difficult to get the crowd to see the importance of doing it "right" and what "right" means. If...
--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 19, 2015 at 9:15 am

#1806733
RE: Need Ammunition for Developers Doing Select *'s

Nadrek (6/19/2015)
Jeff Moden (6/18/2015)
...
if you can't prove it with code, there is no argument.
...
I believe that part of proving it with code is having valid, reliable measurements. 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 19, 2015 at 8:46 am

#1806713
RE: EXCEL HELL!!!

h540663 (6/19/2015)
Good to see someone else has come to the conculsion I came to years ago. Besides, after 15 years of SQL I am still learning and damned if I'm...
--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 19, 2015 at 8:34 am

#1806709
RE: Tricky hierarchy question

lewisdow123 (6/19/2015)
Hi,
I have reposted in here... http://www.sqlservercentral.com/Forums/Topic1695984-3077-1.aspx
Thanks
You really need to stop multi-threading. You should have posted your corrected data on this thread so that others can see the "development"...
--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 19, 2015 at 8:25 am

#1806702
RE: Tricky hierarchy query

lewisdow123 (6/19/2015)
I could kick myself, I am running 2008 R2... so sorry
Heh... not to worry. We wanna kick you, too! 😀
Here's a solution that will work in any...
--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 19, 2015 at 8:23 am

#1806701
RE: EXCEL HELL!!!

pharryecoenen (6/19/2015)
Hi Jeff
Thanks for your reply.
I've seen your stuff at detroit.sqlpass.org and as usual learned a few tricks from it, before trying it.
Works great on 2008R2 after replacing (local)...
--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 19, 2015 at 7:16 am

#1806663
RE: Error converting data type varchar to numeric

Minnu (6/17/2015)
Team
As per my requirment using below script to convert from varchar to numeric.
declare @stg varchar(50)
set @stg='12,000,00'
select CONVERT(NUMERIC(17,2),@stg)
getting error : Error converting data type varchar to numeric
Please help..
If the answer...
--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 18, 2015 at 11:52 pm

#1806586
RE: Interactive sort on a text field having decimal numbers

rockstar283 (6/18/2015)
I have the following text field in SSRS report:
Version
2.0.0.0
1.0.0.0
1.2.0.0
2.1.8.8
...
--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 18, 2015 at 11:46 pm

#1806585
RE: Need Ammunition for Developers Doing Select *'s

ZZartin (6/18/2015)
I'm also not going to listen to a dev without a strong DB background try to defend bad coding standards just because he's lazy.
That's precisely what I was talking...
--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 18, 2015 at 9:44 pm

#1806581
RE: EXCEL HELL!!!

pharryecoenen (6/18/2015)
My conclusion thus far: you can go a long way using openrowset, and the excel files as they arrive, but it all depends, and if I have to open...
--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 18, 2015 at 9:02 pm

#1806579
RE: "Automatic" partitioning

craig.g.smith (6/17/2015)
A common partitioning scenario is when the partition column has the same value for every record in the partition, as opposed to a range of values. Am I...
--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 18, 2015 at 1:56 pm

#1806514
RE: Tricky hierarchy question

Does the real "original" table actually have 5 columns in a manner similar to what your first table is or does it "just" have a "Parent" and "Child" column?
--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 18, 2015 at 1:48 pm

#1806509

Viewing 15 posts - 20,281 through 20,295 (of 59,072 total)