Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,971 through 23,985 (of 59,099 total)

RE: Malicious files on the sql server found

K. Brian Kelley (4/3/2014)
Then you've been working with the wrong security/networking teams. IDS/IPS is typically monitoring network traffic not running on the host. It'll see the xp_cmdshell going across 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)

April 3, 2014 at 4:28 pm

#1703132
RE: Stairway to Advanced T-SQL Level 5: Storing Data in Temporary Tables

mario17 (4/3/2014)
Thanks, Gregory !!
I heard that these days ( after 2008R2) we don't need to CREATE #Temp , you can just do SELECT * INTO #TEMP FROM...
--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 3, 2014 at 4:19 pm

#1703131
RE: Malicious files on the sql server found

K. Brian Kelley (4/2/2014)
Disabling xp_cmdshell is not a false sense of security
There are several good reasons to do this.
1) They prevent against a mistake by someone with privileges who 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 3, 2014 at 9:11 am

#1702908
RE: T-SQL Equivalent for PL-SQL

Siva Ramasamy (4/3/2014)
Thanks for looking into my question. I was not able to understand the usage of connect by statement. Let me try the answer given in the other reply.
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)

April 3, 2014 at 8:37 am

#1702896
RE: Multiple duplicates

rvenkatesan (4/3/2014)
i will make clear,
I am looking for items that have more than one occurrence in track, in the above sample track 204 has 3 distinct Multiples and the track...
--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 3, 2014 at 8:32 am

#1702890
RE: Multiple duplicates

djj (4/3/2014)
Yep I see that now. Again sorry for the misstep.
Nah... not a misstep. I was just making sure. It's good that other people post and 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)

April 3, 2014 at 8:30 am

#1702888
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

kathy.m.davis.ctr (4/3/2014)
Thank you for the excellent information! Is there a way to order the personnel in each level by something besides EmployeeID? My user wants to specify 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)

April 3, 2014 at 8:27 am

#1702885
RE: Memory Optimized tables - large data sets

HowardW (3/26/2014)
I think this misses the point of in-memory optimisation. A read query, like a count, especially on a 1TB RAM server is going to be entirely fulfilled from buffer...
--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 3, 2014 at 8:16 am

#1702873
RE: Multiple duplicates

djj (4/3/2014)
Try running this:
create table #temp1 (Track INT, Books VARCHAR(10))
insert into #temp1 values
(204,'A'),
(204,'B'),
(204,'B'),
(204,'C'),
(206,'A'),
(204,'A'),
(204,'A'),
(203,'A'),
(202,'C'),
(202,'C'),
(202,'B')
SELECT Track, Books FROM #temp1
SELECT DISTINCT Track, Books FROM #temp1
order by 1, 2
Like the OP said, he's not...
--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 3, 2014 at 8:01 am

#1702866
RE: Multiple duplicates

This would do as you ask...
SELECT Track, Books
FROM dbo.YourTable
GROUP BY Track, Books
HAVING COUNT(*) > 1
ORDER BY Track, 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)

April 3, 2014 at 7:58 am

#1702861
RE: Flexible Recursive Level Splitting - One column per level

A view would be good but this requires dynamic SQL to get the dynamic columns. As you probably know, that won't work in a view.
However, considering how fast 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)

April 3, 2014 at 7:53 am

#1702858
RE: Stairway to Advanced T-SQL Level 5: Storing Data in Temporary Tables

Good examples in the article, Greg. I have to take exception to what you listed as "Best Practices", though...
From the article:
Here are few best practices to consider when creating...
--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 2, 2014 at 11:12 pm

#1702723
RE: Suiggestiosn For Choosing The Partition Key

dedicatedtosql (4/2/2014)
Hello All,
I need some guide lines to choose a proper partitioning key for tha tables. LIke below:
What Data type should be choosen?
Can Clurstering Key be diffrent from Partitioning...
--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 2, 2014 at 10:52 pm

#1702722
RE: how to do duration in hours with ragged data

drew.georgopulos (4/2/2014)
Not for nothing, but for me anyway, finding the right stuff here at SCC is really hit or miss.
I agree. It seems like it's always been a problem...
--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 2, 2014 at 10:38 pm

#1702721
RE: decrease the size of log file

You might also want to figure out how it got so big. If there's code that makes it that big or you're not doing TLog backups, that could make...
--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 2, 2014 at 10:31 pm

#1702720

Viewing 15 posts - 23,971 through 23,985 (of 59,099 total)