Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,641 through 20,655 (of 59,098 total)

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
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Excellent. I'll try to take a look at this over the weekend, unless they hit me with the next ton-o-bricks at work.
--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:40 pm

#1800128
RE: Interview Questions

Michael L John (5/22/2015)
Jeff Moden (5/22/2015)As for "standard technical questions", they are a must. The difference is that you don't just sit there and listen to the applicant...
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)

May 22, 2015 at 12:38 pm

#1800126
RE: Interview Questions

jasona.work (5/22/2015)
Jeff Moden (6/6/2014)
thomashohner (6/6/2014)
kimberly_lehman (6/6/2014)
Ask "Using T-SQL, how do you get the current date and time"?
So would you consider this a valid answer? "I think it's CURRENT TIMESTAMP but...
--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 9:21 am

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

At this point, I'm going to suggest that you post your testdata generators and your test harness.
--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 9:19 am

#1800055

Viewing 15 posts - 20,641 through 20,655 (of 59,098 total)