Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,156 through 16,170 (of 59,067 total)

RE: recursive query to find out orphans

There doesn't necessarily need to be a "root tree" in the forest. The landscape can easily have multiple related but still separate trees in the same 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)

December 3, 2016 at 11:31 am

#1915902
RE: RAMDisk? Use it for TempDB?

TheSQLGuru (12/3/2016)
I have to take exception with one thing you said Igor:
With efficient code (t-sql, EF, Linq, ...) you can do wonders.
EF, as in Entity Framework, has been involved...
--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)

December 3, 2016 at 11:27 am

#1915901
RE: passing valus in the group by clause

CELKO (12/3/2016)
in my table, the column names are dynamic ..
SQL does not work this way. By definition, the columns of a table are known and constant and it...
--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)

December 3, 2016 at 11:24 am

#1915900
RE: db growth

HanShi (11/25/2016)
Use the queries below to get the desired information.
Execute it at regular intervals (daily?) and store the results. Build a reporting query on these stored results to get 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)

December 3, 2016 at 9:13 am

#1915894
RE: passing valus in the group by clause

It needs to be dynamic SQL. Details in the code below. Don't ignore the SQL Injection prevention.
--===== This could be a parameter passed to a stored procedure.
DECLARE @pTableName...
--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)

December 3, 2016 at 9:06 am

#1915893
RE: Execute a Powershell script from inside a stored procedure?

Gail Wanabee (12/2/2016)
Jeff Moden (12/1/2016)
Gail Wanabee (12/1/2016)
Jeff, I agree, I just didn't know you could do that. I'm not a Windows Server administrator.
On a complete server reboot, can you recommend...
--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)

December 3, 2016 at 7:44 am

#1915887
RE: Investigate SQL server Shutdown caused by tempdb maxing out.

LearnSQL!!! (11/30/2016)
SQL server got shutdown caused by tempdb maxing out, how can I trace what\who was running at the moment ? Any help would be appropriated.
Correct identification of the 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)

December 3, 2016 at 7:22 am

#1915886
RE: Investigate SQL server Shutdown caused by tempdb maxing out.

Grant Fritchey (12/2/2016)
Talib123 (12/2/2016)
I would try the default trace, if your qucik enough you may get some information of what caused the files to grow and at what time.
The system_health...
--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)

December 3, 2016 at 7:16 am

#1915885
RE: Converting time - from "seconds after midnight"

tacy.highland (12/2/2016)
The only thing I have against these nice simple answers:
As you can see, the neat thing about nice simple answers is that they're nice and simple to modify to...
--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)

December 3, 2016 at 7:10 am

#1915884
RE: Converting time - from "seconds after midnight"

Michael L John (12/2/2016)
Am I missing something, and if not, will this work?
SELECT CONVERT(varchar(20), CONVERT(time, DATEADD(SECOND, ,<Your field containing seconds>, CONVERT(datetime, CONVERT(date, getdate())))), 100)
You're not missing a thing. 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)

December 2, 2016 at 3:26 pm

#1915859
RE: Is there a way to extract only credit card numbers from text

TheSQLGuru (12/1/2016)
SQL CLR Regex would be the way I would go honestly. IIRC someone actually already built a regular expression system for SQL Server using that.
A lot of folks...
--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)

December 2, 2016 at 6:59 am

#1915704
RE: Is there a way to extract only credit card numbers from text

mxy (12/1/2016)
this is a legacy system i am working , trying to mask all the credit card data that is in plain text. But the challenge itself is the way...
--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)

December 1, 2016 at 9:37 pm

#1915615
RE: Is there a way to extract only credit card numbers from text

Manic Star (12/1/2016)
SQL might not be the best tool for this.
You should look at regular expressions processing in another language, they are usually a lot more robust that what...
--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)

December 1, 2016 at 8:53 pm

#1915614
RE: Learn to Earn

Rod at work (12/1/2016)
I hope what you said in this article comes true. Been using Pluralsight to learn new skills. So far, nothing.
It's kind of like winning the lottery... 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)

December 1, 2016 at 8:22 pm

#1915613
RE: can this be done in another way

Just add the necessary ORDER BY with a CASE statement that forces 'Full Time' to be first... like this...
WITH summary AS
(
SELECT p.Studentstatus
...
--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)

December 1, 2016 at 8:14 pm

#1915611

Viewing 15 posts - 16,156 through 16,170 (of 59,067 total)