Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,276 through 22,290 (of 59,102 total)

RE: isDate in SELECT to validate / correct date

So what does the rest of the insert statement look like and what is the error that you're getting? If it's an actual error, please post the actual 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)

December 6, 2014 at 10:38 pm

#1763149
RE: Adding new varchar (30) field to table causes stored procedure to take 10 times more time

You have to remember that EVERY column is a part of the leaf level of the clustered index or a part of the heap. If you added data to...
--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)

December 6, 2014 at 10:35 pm

#1763148
RE: Dynamically grow a data file

MyDoggieJessie (12/6/2014)
Thanks guys, I wasn't aware of these trace flags. I read the article and do have some concerns that Trace flag 1117 will cause all files to grow...
--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)

December 6, 2014 at 12:48 pm

#1763136
RE: Software Projects: the important boring bits

Great article, Phil. Thanks for taking the time to write it.
Having been both an FTE that had to fix legacy systems and a consult that's had to do 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)

December 6, 2014 at 12:44 pm

#1763135
RE: 350GB Data File.. Is it an issue

Perry Whittle (12/6/2014)
Siva Ramasamy (12/6/2014)
It only had one data file (size 350GB). I added another data file (10GB) as soon as I noticed this
Why, what made you think 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)

December 6, 2014 at 12:32 pm

#1763132
RE: 350GB Data File.. Is it an issue

Siva Ramasamy (12/6/2014)
Dear SQL enthusiasts/experts,
Thanks for your interest in my question.
I have recently inherited the administration responsibilities of a production database (SQL 2012) (around 350GB).
It only had one...
--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)

December 6, 2014 at 12:31 pm

#1763131
RE: Dynamically grow a data file

MyDoggieJessie (12/6/2014)
This is more for a case when there are multiple data files in TempDB and I don't wish to set autogrowth because I don't want to risk growing 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)

December 6, 2014 at 9:02 am

#1763123
RE: Enable double-hop kerberos authentication for SQL queries and SQL Reports

Don't be surprised if you SysAdmin refuses to fix the "problem". It's actually a pretty good security "feature".
--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)

December 6, 2014 at 12:16 am

#1763105
RE: Dynamically hourly data extraction in SSIS 2012

BI_NewBie (12/1/2014)
Hi,
Thanks for the reply.
May be i have not cleared my question properly.
My transaction system has huge data and i have asked to pull the data of last 2 months...
--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)

December 6, 2014 at 12:05 am

#1763104
RE: Dynamically grow a data file

Why not just set it to auto-grow?
--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)

December 5, 2014 at 11:59 pm

#1763103
RE: How can I DENY create indexes to a DDL_Admin group

I agree with the previous posts... deny the DDL_Amin priv.
Now, if that doesn't quite work out for you and they have to have the priv to do their job, then...
--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)

December 5, 2014 at 2:23 pm

#1763078
RE: How to restrict User to enter Phone number in words ???

Ed Wagner (12/5/2014)
Eric M Russell (12/5/2014)
The input should be properly parsed and formatted prior to inserting the database table. Really, allowing users to enter all contact information into a multi-line...
--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)

December 5, 2014 at 2:12 pm

#1763074
RE: determin FILEGROUP on my DB in SQL Server

Duplicate post. No replies here, please. It'll just split up the responses. Instead, please respond to the other post which is located at the following link. ...
--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)

December 4, 2014 at 9:19 pm

#1762858
RE: xp_cmdshell issues

Emil Bialobrzeski (12/4/2014)
Jeff Moden (12/3/2014)
IO got lucky... or maybe my Yabingooglewho has gotten a lot better and I found it on the first shot.
http://www.sommarskog.se/grantperm.html
Hi Jeff,
In my first post on 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)

December 4, 2014 at 7:48 pm

#1762850
RE: Convert Integer to Time

craig.bobchin (12/4/2014)
With these tables, an upsert isn't necessary since the records are not updated once they're written. A new record is appended to the tables in Avaya.
Yes... that's understood. ...
--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)

December 4, 2014 at 7:45 pm

#1762849

Viewing 15 posts - 22,276 through 22,290 (of 59,102 total)