Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,611 through 20,625 (of 59,072 total)

RE: Interview Questions

Gosh... that's just the first part of the interview. 😉 We get into the problem solving stuff once we've determined that they have the proper basic knowledge. 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)

May 22, 2015 at 11:23 pm

#1800192
RE: how to optimise the performance of the reports

Jason A. Long (5/22/2015)
Jeff Moden (5/22/2015)
Jason A. Long (5/22/2015)
Lowell (5/19/2015)
look at the report design as well; as mentioned, make sure the underlying query/proceudre is effience and tuned of course,...
--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)

May 22, 2015 at 8:46 pm

#1800190
RE: Balance Sheet Query showing wrong amounts on VAT accounts only

Shifting gears, is To.FinncPriod supposed to skip a couple of beats like this in your CASE statement???
WHEN T0.FinncPriod = '46' THEN '2013-Oct'
WHEN T0.FinncPriod = '45' THEN '2013-Sep'
WHEN T0.FinncPriod = '[font="Arial...
--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)

May 22, 2015 at 8:29 pm

#1800188
RE: Scale out SQL Server Databases

curious_sqldba (5/21/2015)
I have 5 TB single database, we have reached to a point where we cannot scale up anymore, only option is scale out. Would like to know what experts...
--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)

May 22, 2015 at 8:07 pm

#1800186
RE: Scale out SQL Server Databases

curious_sqldba (5/21/2015)
I have 5 TB single database, we have reached to a point where we cannot scale up anymore, only option is scale out. Would like to know what experts...
--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)

May 22, 2015 at 8:07 pm

#1800185
RE: Alter table failed because the minimum row size would be 8061, including 8035 bytes of internal overhead

As a total swag on my part, try running DBCC CLEANTABLE on the table giving you the problems and see if you still get an error.
--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)

May 22, 2015 at 7:50 pm

#1800184
RE: Understanding CAST(INT AS DATETIME)

thomashohner (5/22/2015)
My answer probably has some logic holes in it and not as elegant as yours Jeff, but this is what I put
When using the Month(18/200) or (200/18) the Resulting...
--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)

May 22, 2015 at 7:42 pm

#1800183
RE: how to optimise the performance of the reports

Jason A. Long (5/22/2015)
Lowell (5/19/2015)
look at the report design as well; as mentioned, make sure the underlying query/proceudre is effience and tuned of course, but check this out:
i inherited...
--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)

May 22, 2015 at 7:36 pm

#1800182
RE: Generating Permutations in T-SQL

Frédéric BROUARD (1/8/2009)
This calculus can be done in only one query
(I think I am the first to demontsrate how to do that in one query only !) 😉
-- lest's assume...
--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)

May 22, 2015 at 6:19 pm

#1800179
RE: Understanding CAST(INT AS DATETIME)

thomashohner (5/22/2015)
The original Trivia question was for a $50 Amazon gift card.
It was why does MONTH(18/200) AND MONTH(200/18) both return 1's.
CAST INT to Datetime was part of me trying...
--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)

May 22, 2015 at 5:28 pm

#1800176
RE: Understanding CAST(INT AS DATETIME)

GilaMonster (5/21/2015)
Definitely a poor practice (it's confusing) and only works with DATETIME, not DATE, NOT DATETIME2, not DATETIMEOFFSET
"It Depends".
--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)

May 22, 2015 at 3:11 pm

#1800159
RE: Sql query to convert varbinary to datetime

SQLRNNR (5/22/2015)
um yeah - would have never figured that one out. Why do they insist on obfuscating things to that degree like that?
They probably have no clue that's 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)

May 22, 2015 at 2:44 pm

#1800154
RE: How to check the size of the database after implemeting data compression across all tables

parag.sv (5/22/2015)
Hi, I guess everyone's suggesting be careful before using compression but no one's answering your question.
Yes, it will show the database size same as it was before you compressed...
--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)

May 22, 2015 at 2:11 pm

#1800145
RE: Need to Generate Incrementing Number with Conditional Restart - Please Help

jkalmar 43328 (5/22/2015)
8 views and no answers - is my question really hard or really stupid? 😉
Heh... you couldn't do it now, could you? You need to be patient....
--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)

May 22, 2015 at 2:00 pm

#1800144
RE: Are the posted questions getting worse?

Brandie Tarvin (5/22/2015)
Gazareth (5/22/2015)
Jack Corbett (5/22/2015)
We do have white noise generators
Huh?
They kind of look like smoke detectors, usually installed in the ceiling tiles. They cover about 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)

May 22, 2015 at 12:42 pm

#1800129

Viewing 15 posts - 20,611 through 20,625 (of 59,072 total)