Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,401 through 17,415 (of 59,067 total)

RE: What's the reason?

Charmer (6/23/2016)
Hi Friends,
I had a question during my interview, as saying that What could be the reason when I am trying to drop all these tables , views, functions, SP's...
--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)

June 24, 2016 at 4:30 pm

#1886864
RE: Query

If the hierarchy is large, consider the use of Nested Sets while still maintaining the Adjacency List. See the following articles for how to do such a thing 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)

June 24, 2016 at 4:17 pm

#1886861
RE: Are the posted questions getting worse?

Luis Cazares (6/24/2016)
Sean Lange (6/24/2016)
Ugh....just needing to share this unbelievably ridiculous mess I just stumbled across.
create view [dbo].[getNewID] as select newid() as new_id;
Really? A view to get a guid???
But wait...it...
--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)

June 24, 2016 at 10:22 am

#1886798
RE: Are the posted questions getting worse?

Sean Lange (6/24/2016)
Ugh....just needing to share this unbelievably ridiculous mess I just stumbled across.
create view [dbo].[getNewID] as select newid() as new_id;
Really? A view to get a guid???
But wait...it gets even...
--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)

June 24, 2016 at 10:20 am

#1886796
RE: Monitor/alert - Table row growth

SQL!$@w$0ME (6/22/2016)
Hi Folks,
Anyone has a script/documentation to monitor/alert table growth by percentage or number of rows.
Many thanks.
Based on what and when? The condition just before'n'after a given insert or...
--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)

June 23, 2016 at 3:34 pm

#1886637
RE: Concatenate strings

curious_sqldba (6/22/2016)
Sean Lange (6/22/2016)
curious_sqldba (6/22/2016)
Thanks. This is just displaying, i want to store the data in the variable and then use the variable different places.
Do you know how to use...
--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)

June 23, 2016 at 2:36 pm

#1886632
RE: Are the posted questions getting worse?

On the "Brexit" thing, the folks in GB really need to consider the ramifications to their automotive industries. The EU has a 10% import tax and GB sells 4...
--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)

June 23, 2016 at 1:25 pm

#1886616
RE: A SQL Server Date Handling Issue

trboyden (6/21/2016)
Jeff Moden (6/20/2016)
trboyden (6/20/2016)
SQL Server expects the date to be passed in as "2016-06-20 00:00:00"
That's not true at all. SQL Server will take a couple dozen date/time formats...
--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)

June 23, 2016 at 7:45 am

#1886531
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

David Moutray (6/22/2016)
Classic article, Jeff. I have loved it (and used it extensively) since it first came out five years ago (and the discussion is still going strong!)
With SQL...
--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)

June 22, 2016 at 9:22 pm

#1886410
RE: Are the posted questions getting worse?

Ed Wagner (6/22/2016)
Grant Fritchey (6/22/2016)
Being a different kind of science fiction fan, one of my horrors is the world government that will tell us all what to do, how 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)

June 22, 2016 at 8:54 am

#1886287
RE: Run a query when the cluster node fails from one node to the other

sunny.tjk (6/20/2016)
I'd like to run a query when the cluster node fails from node one node to the other.
Can someone help me achieve this?
I somehow feel looking through the errorlog...
--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)

June 21, 2016 at 5:46 pm

#1886131
RE: Your thoughts on dropping redundant indexes...

I have see cases where, for example, a clustered index was used on a date column and, of course, in queries. In this case that I'm speaking of, there...
--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)

June 21, 2016 at 5:01 pm

#1886128
RE: Updating A CTE Which Based On Multiple Tables

SQLUSERMAN (6/17/2016)
I've read that when updating a CTE which is based on multiple tables, if the update affects just one
of the tables which make up the CTE, then the update...
--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)

June 21, 2016 at 4:55 pm

#1886127
RE: TSQL query slower with variable than hard-coded

tindog (6/21/2016)
Appreciate the help Sergiy - however think I ditched/resolved this one 6 months ago!
You previous post on this thread was "only" 2 months and 3 weeks ago where you...
--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)

June 21, 2016 at 4:33 pm

#1886126
RE: A SQL Server Date Handling Issue

Judging by the low marks of this article and people saying the "OP" wrote "stupid" code, I think that a lot of people think the author wrote this code.
The author...
--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)

June 20, 2016 at 7:48 pm

#1885944

Viewing 15 posts - 17,401 through 17,415 (of 59,067 total)