Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,601 through 21,615 (of 59,098 total)

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
RE: How to calculate cumulative numbers

Henk Schreij (2/6/2015)
Eirikur and Sean, thank you.
I have SqlServer 2012 on my developper machine, but the production machine is 2005 :crying:.
Now I gona try to fit my query...
--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 7, 2015 at 8:40 pm

#1776237
RE: How to calculate cumulative numbers

Eirikur Eiriksson (2/6/2015)
Further on Sean's answer, here is the "hard way" (don't worry, the server does the work:-D) of doing a running total on SQL Server 2008 and earlier
😎
USE tempdb;
GO
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)

February 7, 2015 at 8:39 pm

#1776236
RE: Powershell parameters

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 using the wrong...
--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 6, 2015 at 6:52 am

#1776037
RE: Long Running Update statement

jdbrown239 (2/5/2015)
Hi
I am running an update against a table with over 100,000,000 rows which takes forever. Is there a better way to write a query like this?
UPDATE [dbo].[Test_Table]
SET [Column_34] =(
CASE
WHEN...
--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 5, 2015 at 9:21 pm

#1775943

Viewing 15 posts - 21,601 through 21,615 (of 59,098 total)