Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,571 through 21,585 (of 59,072 total)

RE: Traversing down a tree

mark.worthen (2/9/2015)
I'm working with a development bug database where if someone puts in a bug number, they want to get the parent bug. No problem.
SET @cur_parent = (SELECTdupeof_key
FROMqds.dbo.Dimduplicates d...
--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:00 pm

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

Joy Smith San (2/9/2015)
I am planning to give them rights to find and kill their queries, if they cannot fine tune it.
Really, [font="Arial Black"]REALLY [/font]bad idea.
--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 12:51 pm

#1776734
RE: Need to load 4 different csv files into 4 diffrent tables using t sql in one sql can't use ssis

While I'm a great lover of xp_CmdShell, there's no need for it just to get the file names. You can use xp_DirTree "pathname",1,1 to get a list of 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)

February 10, 2015 at 9:20 am

#1776667
RE: Help, unable to update linked Excel File

I realize this post is almost a half decade old but I did come across it while searching for an answer to the very same problem and figure others 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)

February 9, 2015 at 5:46 pm

#1776511
RE: values in two columns?

patrickmcginnis59 10839 (2/9/2015)
Stack exchange is a personal go to for information on a span of subject matter that vastly exceeds anything sqlservercentral will EVER aspire to in the slightest
Having...
--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 9, 2015 at 11:54 am

#1776471
RE: Slow Queries with Linked Server

Eric M Russell (2/9/2015)
axc_67 (2/9/2015)
No I am not joining any tables in the remote server.
I am just pulling a simple data extraction from remote server with where conditions....which is why...
--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 9, 2015 at 11:48 am

#1776468
RE: The Number that shouldn't be a number

t.pinder (2/9/2015)
One system stores sex as an int... well sort of. It actually stores it as two int columns. One int column is called Male and the other column 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 9, 2015 at 10:43 am

#1776452
RE: incrementing alpha string using SQL

K2mission (2/9/2015)
Sean,
The thought was to allow for as many 6-character combinations as possible. Using the alphabet along with numbers offered 2,176,782,336 combinations whereas numbers alone would only offer 1,000,000 (zero-base)....
--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 9, 2015 at 9:21 am

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

Joy Smith San (2/9/2015)
Thanks Gila.
Yes, I have already conveyed to them. I even passed them the queries they need to look at long ago.
Think its done with some pathetic design...
--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 9, 2015 at 8:56 am

#1776395
RE: Shall i study DBA ?

Learning anything is a help, of course, but I don't know how to program in C# or Java and I'm not much more than a casual user of PowerShell 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)

February 9, 2015 at 8:51 am

#1776394
RE: Long Running Update statement

Jason-299789 (2/9/2015)
jdbrown239 (2/8/2015)
I will have to profile the data for uniqueness to see if a clustered index can be created.
Don't get confused between a PK and a clustered index, 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)

February 9, 2015 at 8:31 am

#1776387
RE: LinkedServer using Microsoft.ACE.OLEDB.12.0 for Excel worksheet

In the category of "Better Late than Never", the following link seems to have an answer to your Temp folder woes.
http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm
This problem reportedly only occurs on 32 bit machines so...
--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 8, 2015 at 11:25 pm

#1776296
RE: wait for delay inside a fuction

wannabe1 (1/14/2015)
i wanna wait for some time(seconds) to get a delta on resources and i want it as a function to sort based on columns
thanks for the reply.
You should...
--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 8, 2015 at 8:34 am

#1776251
RE: Programming Rules and 'Best Practices' Can't Replace Professional Judgement

From the article:
It is strange how the gradual repetition of advice that was once guarded, nuanced, and garnished with conditions, transforms it into cast-iron rules.
+1000, Phil.
The notion also applies heavily...
--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 8, 2015 at 8:28 am

#1776247
RE: values in two columns?

CELKO (2/7/2015)
>> At the bottom is a list of physician and surgeon keys. They can be in either the F.attphys_key or F.surgeon_key field [sic]. if any one of these keys...
--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 8, 2015 at 7:46 am

#1776245

Viewing 15 posts - 21,571 through 21,585 (of 59,072 total)