Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,556 through 21,570 (of 59,072 total)

RE: foreach loop in sql

nwtsqlserv (2/11/2015)
I already have a spitter function mate...please have a read through my question again...thanks.
Could you post the code for your splitter, please?
--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)

February 11, 2015 at 6:47 pm

#1777124
RE: Intermittent error: Cannot open database "DBNAME" requested by the login. The login failed. Login failed for user 'USER'.

lfajardo (2/11/2015)
We ended up fixing the problem by rebooting our database server and applications servers that connect to it. Still unclear what caused the problem, if someone has 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)

February 11, 2015 at 4:43 pm

#1777108
RE: Traversing down a tree

mark.worthen (2/11/2015)
CELKO (2/11/2015)
Please follow basic Netiquette and post the DDL we need to answer this. Follow industry and ANSI/ISO standards in your data. You should follow ISO-11179 rules for naming...
--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)

February 11, 2015 at 4:08 pm

#1777106
RE: Traversing down a tree

CELKO (2/11/2015)
Please follow basic Netiquette and post the DDL we need to answer this. Follow industry and ANSI/ISO standards in your data.
{snip}
You talk about the bugs as a hierarchy. Since...
--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)

February 11, 2015 at 3:59 pm

#1777105
RE: Traversing down a tree

mark.worthen (2/11/2015)
By the way, I created a basic, limited workaround.
I created a table which takes the table and self-joins it nine times giving me up-to 10 generations of duplicates 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)

February 11, 2015 at 1:11 pm

#1777051
RE: Traversing down a tree

Yes. It makes sense.
So, just to clarify... if we did a search for all rows in this table where the "parent" ID was NOT contained in the "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)

February 11, 2015 at 9:05 am

#1776977
RE: Traversing down a tree

mark.worthen (2/11/2015)
Jeff Moden (2/10/2015)
Is it an absolutely true parent/child relationship where no child can be it's own parent and that each child has one and only one parent?
Yes. No...
--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)

February 11, 2015 at 8:31 am

#1776961
RE: How to kill current queries taking most cpu.

Sean Lange (2/11/2015)
admin 31599 (2/11/2015)
--Current queries SELECT r.session_id, s.TEXT, r.[status], r.blocking_session_id, r.cpu_time, r.total_elapsed_time FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s
Find blocking_session_id or heavy one and then
kill #
If using this script very often the next step 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)

February 11, 2015 at 8:22 am

#1776950
RE: Powershell parameters

Mighty (2/6/2015)
Jeff Moden (2/6/2015)
Heh... for me, the correct answer isn't available, which is "Don't worry about it because if it's to do something in SQL, then it's likely that you're...
--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)

February 11, 2015 at 8:01 am

#1776941
RE: Very little space of harddisk problem

It would be nice to remove unused indexes but it does take a bit to prove that they're truly unused. Unless you have a monster index that we can...
--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)

February 11, 2015 at 7:54 am

#1776940
RE: Looking for an elegant way to tranpose my query result

halifaxdal (1/19/2015)
Jeff Moden (1/19/2015)
To add to that, you're grouping by the wrong column. You need to group by the BOX TYPE column.
I am not grouping on the wrong 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)

February 10, 2015 at 8:30 pm

#1776816
RE: Very little space of harddisk problem

WhiteLotus (2/10/2015)
Ahhh sorry
the fragmentation level for the first index is very high : 98.77 %
and the second one is : 3.93 %
the fragmentation level will impact on the index...
--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)

February 10, 2015 at 6:42 pm

#1776805
RE: Traversing down a tree

dwain.c (2/10/2015)
Jeff Moden (2/10/2015)
Is it an absolutely true parent/child relationship where no child can be it's own parent and that each child has one and only one parent?
Why do 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)

February 10, 2015 at 6:27 pm

#1776804
RE: Very little space of harddisk problem

WhiteLotus (2/10/2015)
Hi Jeff
Thanks for you reply
The largest index is PK_Index1 , size : 15 GB , Pages : 2.051.264
it is clustered Index
The second largest is PK_Index2 ,...
--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)

February 10, 2015 at 5:48 pm

#1776800
RE: Very little space of harddisk problem

WhiteLotus (2/10/2015)
Hi All,
My current disk drive has 4 GB free only . Total : 60 GB
It has 1 DB that has 40 GB mdf file and 15 GB ldf...
--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)

February 10, 2015 at 5:08 pm

#1776795

Viewing 15 posts - 21,556 through 21,570 (of 59,072 total)