Viewing 15 posts - 406 through 420 (of 476 total)
_simon_ (9/14/2015)
This is really off topic
I don't think so 🙂 it is often helpful to understand the problem, rather than the proposed solution, because that may enable alternative, and hopefully...
September 15, 2015 at 1:36 am
Lynn Pettis (9/14/2015)
-- set @Debug = 1set @Debug = 1;
What in the world does the comment add to this piece of the code.
Indeed. I find it very confusing because the...
September 15, 2015 at 1:14 am
sqllearner1234 (9/14/2015)
OR a.banner_tag = cast(b.banner_tag as varchar)
OR ...
September 14, 2015 at 3:56 pm
You would have to test it 🙂 but the TOP has to re-perform the query to get the next batch, whereas the Temp Table FROM-TO Range should be using clustered...
September 14, 2015 at 1:08 pm
Jacob Wilkins (9/14/2015)
Well, he did say that the shrinking is of the log files, so that isn't contributing to index fragmentation, methinks 🙂
I agree. I'd diverted to start worrying about...
September 14, 2015 at 1:05 pm
Matt Miller (#4) (9/14/2015)
Just to be clear - I was still talking about Eric's premise (build your own DBMS).
I was picking up on your point about the pain that it...
September 14, 2015 at 1:01 pm
Matt Miller (#4) (9/14/2015)
where the savings justify the pain and cost you're putting your user base through.
We are surrounded by "cheap" here (UK side). Maybe different where you are?
Big...
September 14, 2015 at 11:02 am
mar.ko (9/14/2015)
Mine was one line of code to describe the list and one line of code to convert it to a table via the function call !
How are you going...
September 14, 2015 at 10:53 am
Make it 10,000 sales or 100,000 to amortise over then. All the clients we have, even large ones, wince at the cost of SQL "on top of the cost...
September 14, 2015 at 10:46 am
krypto69 (9/14/2015)
I am running my weekly maintenance plans that use Ola's script for DBCC CHECKDB.
Naive question but does that include Index Rebuild, as well as CHECKDB?
krypto69 (9/14/2015)
September 14, 2015 at 10:31 am
Matt Miller (#4) (9/14/2015)
September 14, 2015 at 10:27 am
🙂 Your point about Affluence is important though. I tend to think in terms of "getting goods delivered" but no doubt our clients are also reporting using geo-coding...
September 14, 2015 at 10:06 am
crmitchell (9/14/2015)
Dealing with partial postcodes greatly complicates things.
Indeed ... ultimately its should be down to whatever the Client wants ...
"Is B91 really B91 or is it supposed to be B9...
September 14, 2015 at 9:42 am
Phil Parkin (9/14/2015)
This is not correct. They can insert into local table variables, which are then returned by the function.
Sorry, I mistook @RETABLE as a parameter to the Function,...
September 14, 2015 at 9:35 am
mar.ko (9/14/2015)
What I am trying to do is develop a function whereby a pass a number and then I get a set of tablenames returned as a table.
A Table Valued...
September 14, 2015 at 9:31 am
Viewing 15 posts - 406 through 420 (of 476 total)