Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,651 through 25,665 (of 59,099 total)

RE: Find value of cell from header name and row name (like going down and across)

PiyaKaGhar (10/11/2013)
Hi can I insert image to show,
UPDATE [dbo].[pro]
SET [Test] = <Test, nchar(10),>
,[100] = <100, nchar(10),>
...
--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)

October 12, 2013 at 11:30 am

#1658083
RE: Reason for Column statistics

Yuri55 (10/12/2013)
Just curious- how column statistics that is not part of any index is used?
Thanks
It can help the optimizer figure out whether or not to actually use an 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)

October 12, 2013 at 11:20 am

#1658082
Reply To: Fragmentation doesn't changes after index rebuilding

Alan.B (10/11/2013)
sandeep singh-337370 (10/11/2013)
Guys,
One of the other project's guys in my company asked me to improve the performance of their databases.
Keeping your indexes un-fragmented will help performance. That said, 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)

October 12, 2013 at 11:12 am

#1658081
RE: Are the posted questions getting worse?

L' Eomot Inversé (10/11/2013)
It must be really nice to have every company bugeting in step
They don't, really. Like so many other countries, many company's budget year is different than...
--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)

October 12, 2013 at 10:45 am

#1658079
RE: running tsql from filetable

And with that and the fact that I've seen many people try to do the same thing, I guess now would be a great time to ask...
... what's wrong with...
--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)

October 12, 2013 at 9:10 am

#1658074
RE: How to write Query on the Result Set of Another Query

lrosini (10/11/2013)
As Jeff showed there are many ways to do this. I only provided one possibility.
I've been a silent observer on this site for along time and finally feel that...
--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)

October 12, 2013 at 9:04 am

#1658073
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

The feedback is worth more than the stars. Thanks, Steen!
--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)

October 12, 2013 at 9:02 am

#1658072
RE: Are the posted questions getting worse?

Stefan Krzywicki (10/11/2013)
Revenant (10/10/2013)
WayneS (10/10/2013)
Stefan Krzywicki (10/8/2013)
Well, time to polish the resume and start looking for work. Just given a 1 month notice.
They want to keep me on a retainer...
--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)

October 11, 2013 at 3:47 pm

#1658034
RE: TempDB question

sunny.tjk (10/11/2013)
Does having multiple tempdb files on different drives help with contention?
Yes... especially if they're on different drives.
--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)

October 11, 2013 at 3:33 pm

#1658028
RE: How to write Query on the Result Set of Another Query

perireddy.arikatla (10/10/2013)
Hai Every One. Can Any body help me Please.
I Want to Write a Query On the Result Set Of Another Query.
How to Write
Can Any body...
--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)

October 11, 2013 at 3:32 pm

#1658027
RE: Fragmentation doesn't changes after index rebuilding

sandeep singh-337370 (10/11/2013)
It remained same even for the larger tables.
What do you condsider to be a "larger 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)

October 11, 2013 at 3:27 pm

#1658026
RE: index scan vs seek

Snargables (10/11/2013)
i have a table that has 600 mill recs. i have an update to it that modifies 79 k records a day. Up to last saturday at 8am this...
--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)

October 11, 2013 at 3:24 pm

#1658025
RE: running tsql from filetable

AK1516 (10/11/2013)
I have used the filetable to store the tsql scripts. what can be the best way to run them against the server. the only road block i have using...
--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)

October 11, 2013 at 3:22 pm

#1658024
RE: Running out of workers

I don't personally have any good sources for how to troubleshoot connection leaks. They can happen in the front-end or in SQL code (usually because of not closing connections...
--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)

October 11, 2013 at 7:54 am

#1657920
RE: how to split the comma delimited string into rows without using LOOP, CTE, XML.

For more information on SQL Injection, my recommendation would be to Google it. It's a large subject and contains way too much information for me to post on a...
--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)

October 11, 2013 at 7:42 am

#1657915

Viewing 15 posts - 25,651 through 25,665 (of 59,099 total)