Forum Replies Created
Viewing 15 posts - 18,571 through 18,585 (of 59,098 total)
-
RE: How to figure out whether data is selected from dirty pages?
Hugo Kornelis (1/21/2016)
I don't think that's possible.Also, even if you know what data is from dirty pages, you still do not have the full picture. Using read uncommitted can also...
--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) -
RE: Tree stucture
I'm still interested in why this needs to be done, especially in T-SQL but it would appear the OP has flown the coop.
--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) -
RE: What is recursion?
To me (programming wise), recursion is nothing more than a loop and has all of the same problems as a loop except there's no explicit loop making it a bit...
--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) -
RE: Security Convenience
Steve Jones - SSC Editor (1/19/2016)
Jeff Moden (1/15/2016)
Heh... the title of this article should be titled "Security vs Convenience" because the current title is actually a bit of an oxymoron.What...
--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) -
RE: Having fun with PARSENAME (SQL Spackle)
robert.sterbal 56890 (1/19/2016)
The spackle articles would do well on a wiki.You know, that's a great idea. Steve Jones was talking about "exercises" for folks and that would fit 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) -
RE: Are the posted questions getting worse?
jasona.work (1/19/2016)
Paintball is getting more and more complicated...I wonder if it'll work with Express or if it needs Enterprise?
I've been outlawed from paint ball forever... I threatened to build 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) -
RE: The DBA Tax
natewest (1/19/2016)
I must admit when I heard "The DBA Tax" the first thing that popped into my head was "Buying Pizza for the DBA team so that they execute my...--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) -
RE: what will happen?
Eirikur Eiriksson (1/19/2016)
Jeff Moden (1/19/2016)
Rodan (1/19/2016)
So if Trump is elected in the US – do you think we have to worry about him putting up fences around our foreign 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) -
RE: Checking the bitwise value of an integer
Jacob Wilkins (1/19/2016)
Eirikur Eiriksson (1/19/2016)
aaron.reese (1/19/2016)
@jacob and @jeffSSRS is not my natural home 😀 so I was not aware that IIF(x AND y) is a bitwise operation. Maybe 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) -
RE: what will happen?
Rodan (1/19/2016)
So if Trump is elected in the US – do you think we have to worry about him putting up fences around our foreign keys? :w00t:Heh... every time 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) -
RE: Partition Table by Year
Welsh Corgi (1/19/2016)
EXEC sp_SpaceUsed tblCallname rows reserved ...
--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) -
RE: Partition Table by Year
I'll also add that the people that want to do the partitioning for performance are making a big mistake. Partitioning doesn't improve performance in almost every case. Proper...
--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) -
RE: Partition Table by Year
Welsh Corgi (1/19/2016)
There are only 1,296,391 records but the table is wide.I recommended that we did not partition the table. There is too much risk among other things but someone...
--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) -
RE: Partition Table by Year
J Livingston SQL (1/19/2016)
deja vuhttp://www.sqlservercentral.com/Forums/Topic1696588-3077-1.aspx
Heh... I thought this looked familiar.
My advice in my previous post stands, though. 🙂
--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) -
RE: Partition Table by Year
Welsh Corgi (1/19/2016)
The records in the call table are updated Regularly.Thanks.
So, you're saying that rows for calls placed in 2014 can be updated in 2016? Something is VERY 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)
Viewing 15 posts - 18,571 through 18,585 (of 59,098 total)