Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,801 through 25,815 (of 59,099 total)

RE: Need Help on Fastest Search Logic

born2achieve (9/28/2013)
Hi,
I have two tables named "Table1" and "Table2".
Table1 Details:
id bigint, product_name nvarchar(1000),quantity int
records count on Table1 : 25000( may increase in future)
Table2 Details:
id bigint, product_name nvarchar(max),details nvarchar(1000),...
--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)

September 29, 2013 at 5:06 pm

#1654375
RE: Prevent backups on C:\ drive?

andrew gothard (9/29/2013)
kevaburg (9/28/2013)
Kurt W. Zimmerman (9/27/2013)
I find this question somewhat puzzling. All of my backups go to a designated backups folder. I have never created a backup...
--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)

September 29, 2013 at 4:43 pm

#1654373
RE: Prevent backups on C:\ drive?

andrew gothard (9/27/2013)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
I absolutely love that. Well said.
--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)

September 29, 2013 at 4:39 pm

#1654372
RE: calculate database size

LOVER OF SQL (9/27/2013)
Friends,
how can i calculate database size with this information:
Processed 8192240 pages for database 'DBOLTP', file 'rm' on file 1. ??
(8192240 *8) = 65537920 (bytes) / 1024 /...
--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)

September 29, 2013 at 4:27 pm

#1654370
RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

dastagiri16 (9/25/2013)
hi,
one of the interviewer asked the question about updating...so i have added test table like below...
USE [Practice]
GO
/****** Object: Table [dbo].[mytable] Script Date: 09/25/2013 13:10:59 ******/
SET...
--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)

September 29, 2013 at 4:11 pm

#1654368
RE: Are the posted questions getting worse?

Luis Cazares (9/29/2013)
Jeff Moden (9/29/2013)
I'm am totally afraid for this person...
http://www.sqlservercentral.com/Forums/Topic1499747-391-1.aspx
For this person or for his/her company?
Yes! 😉
--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)

September 29, 2013 at 3:14 pm

#1654362
RE: Are the posted questions getting worse?

GilaMonster (9/29/2013)
Oh dear....
If I may change the topic... For the purposes of a book chapter, what are your favourite statistics-related myths?
1. People that think that Temp Tables don't have...
--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)

September 29, 2013 at 3:12 pm

#1654361
RE: Are the posted questions getting worse?

I'm am totally afraid for this person...
http://www.sqlservercentral.com/Forums/Topic1499747-391-1.aspx
--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)

September 29, 2013 at 2:55 pm

#1654354
RE: Are the posted questions getting worse?

Congrats to you both, Lynn!
--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)

September 29, 2013 at 4:12 am

#1654330
RE: Are the posted questions getting worse?

GilaMonster (9/28/2013)
Jeff Moden (9/27/2013)
Speaking of "Are the posted questions getting worse"?... I was going through some old responses to some posts and I came across this one that no one...
--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)

September 28, 2013 at 12:31 pm

#1654308
RE: Are the posted questions getting worse?

GilaMonster (9/28/2013)
Here things are still getting worse (mining problems and government blunderings not helping), so I'm seeing less demand for competant (expensive) people and more 'oh, you've done a university...
--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)

September 28, 2013 at 12:26 pm

#1654307
RE: Are the posted questions getting worse?

Speaking of "Are the posted questions getting worse"?... I was going through some old responses to some posts and I came across this one that no one responded 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)

September 27, 2013 at 8:39 pm

#1654243
RE: Is possible create numbered sequences

Gosh, I'm sorry. I see that this post is 6 weeks old and no one picked up on it. The following will do it for you. Change...
--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)

September 27, 2013 at 8:06 pm

#1654240
RE: What is your favorite "I didn't know that" moment in T-SQL?

Apologies for the very late reply, Tom. Thanks for the detailed explanation about xp_CmdShell in SQl Server 2000. I knew a good amount of that but it was...
--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)

September 27, 2013 at 6:18 pm

#1654235
RE: Shift week to Wed - Tues

Michael Valentine Jones (9/27/2013)
Jeff Moden (9/26/2013)
Michael Valentine Jones (9/26/2013)
Jeff Moden (9/26/2013)
Michael Valentine Jones (9/25/2013)
That's not really the best way to go because it depends on the setting of a run-time...
--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)

September 27, 2013 at 3:59 pm

#1654219

Viewing 15 posts - 25,801 through 25,815 (of 59,099 total)