Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,936 through 22,950 (of 59,067 total)

RE: Inline syntax for indexes

GilaMonster (8/11/2014)
Jeff Moden (8/11/2014)
Now that would be nice in "regular" T-SQL.
Err.. It is in regular T-SQL, from SQL 2014 onwards.
I'm so far behind that I'll need to be twins...
--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)

August 11, 2014 at 4:43 pm

#1737071
RE: Rebuild Online Index in Partationed Table

pawana.paul (8/11/2014)
All,
Need your help.
I joined new environment. There is one table of 1.6 TB which has 16 partations. SQL Server Version is 2008 R2. We are planning to perform maintenance...
--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)

August 11, 2014 at 4:16 pm

#1737068
RE: Plagiarism and Blog Spam

chrisn-585491 (8/11/2014)
Jeff,
Sent you a private message with a link. Didn't want to unleash the wolves.
Thanks!
Chris
Understood. Thanks.
--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)

August 11, 2014 at 2:41 pm

#1737038
RE: Inline syntax for indexes

Now that would be nice in "regular" T-SQL. Thanks for jumping in, Gail.
--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)

August 11, 2014 at 12:56 pm

#1737002
RE: Plagiarism and Blog Spam

chrisn-585491 (8/11/2014)
I frequent other forums elsewhere and have ran into an issue with another user that frequently post links to his blog about SQL Server and other IT issues. 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)

August 11, 2014 at 10:53 am

#1736946
RE: Inline syntax for indexes

sektor81 (8/11/2014)
I wonder whether there's documentation about inline syntax for indexes for SQL Server 2014? I couldn't find it here.
CREATE TABLE Consumer
(
Account nvarchar(20) null,
Consumption...
--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)

August 11, 2014 at 10:51 am

#1736945
RE: SQL DBA high ended question (5+ years’ experience)

Beatrix Kiddo (8/11/2014)
Some of these sound more like questions I'd ask of a developer (or a Development DBA, maybe).
That too! I do like DBAs that actually know something about...
--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)

August 11, 2014 at 9:28 am

#1736925
RE: Introducing the Columnstore Index

Has anyone actually used this feature in production, yet?
--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)

August 10, 2014 at 9:20 pm

#1736688
RE: What do you consider important when performance testing?

For single row queries normally associated with the front end, fragmentation means almost nothing because you're stuck with looking up single rows.
For batch file code, I normally don't test against...
--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)

August 10, 2014 at 9:16 pm

#1736686
RE: How to replace null value in a query

New_2SQL (8/10/2014)
On my laptop the old source code took 546ms whereas your new source code took 124ms only. Very good improvement.
For how many rows in the tables?
--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)

August 10, 2014 at 9:06 pm

#1736685
RE: Table Partitioning Question

alex_pixley (8/8/2014)
If I get rid of partitions 8-13 and then implement sliding window on a yearly basis, I will never have more than seven years worth of data. 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)

August 10, 2014 at 9:13 am

#1736660
RE: Breaking down T-SQL requirements (methodology)

Ah. Gotcha.
I also enforce a set of fairly strict but very easy to comply with set of standards both at work and upon myself.
--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)

August 10, 2014 at 9:02 am

#1736659
RE: Breaking down T-SQL requirements (methodology)

TeraByteMe (8/9/2014)
That is pretty much the approach I have been seeing everywhere. So I guess it is the way it is done. I just thought maybe someone would have documented...
--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)

August 9, 2014 at 2:39 pm

#1736632
RE: db owner

GilaMonster (8/9/2014)
sqlfriends (8/8/2014)
But my question is why bother to grant all these permssions, but just grant this account db_owner role. Becaue it pretty much need all the permissions: read, write,...
--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)

August 9, 2014 at 10:50 am

#1736625
RE: advice for questions to ask regarding new database for 3rd party application

churlbut (8/7/2014)
How about Security, who needs access/what kind of access.
+1 Billion. I also want to know if there are things like personally identifiable information (especially tax IDs, CC #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)

August 9, 2014 at 10:27 am

#1736623

Viewing 15 posts - 22,936 through 22,950 (of 59,067 total)