Jeff Moden

Forum Replies Created

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

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
RE: Best way for dynamic partitioning of table sql server

BI_NewBie (12/3/2014)
Hey Jeff!!
Thanks for your reply.
In my database, there is a transaction table whose row count is 117690142. There are index created on column but still when we fire any...
--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 12:21 am

#1762590
RE: Best way for dynamic partitioning of table sql server

BI_NewBie (12/3/2014)
Hello all,
Greetings!
I need suggestion on Dynamic Partition of SQL Table. I have done my homework on this topic but still below questions are still stuck in my mind.
1. ...
--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 3, 2014 at 10:06 pm

#1762579
RE: Convert Integer to Time

Jeff Moden (12/3/2014)
craig.bobchin (12/3/2014)
Got it!!!
declare @MaxRowdateTime datetime
select @MaxRowdateTime = max(DATEADD(day, DATEDIFF(day,'19000101',row_date), CAST(CONVERT( TIME, STUFF( RIGHT( '0000' + CONVERT( VARCHAR(5), starttime), 4), 3, 0, ':')) AS DATETIME2(7)))) from [avaya].[dbo].[hSplit]
select
DATEADD(day,...
--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 3, 2014 at 9:45 pm

#1762578
RE: Convert Integer to Time

craig.bobchin (12/3/2014)
Got it!!!
declare @MaxRowdateTime datetime
select @MaxRowdateTime = max(DATEADD(day, DATEDIFF(day,'19000101',row_date), CAST(CONVERT( TIME, STUFF( RIGHT( '0000' + CONVERT( VARCHAR(5), starttime), 4), 3, 0, ':')) AS DATETIME2(7)))) from [avaya].[dbo].[hSplit]
select
DATEADD(day, DATEDIFF(day,'19000101',row_date), CAST(CONVERT(...
--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 3, 2014 at 9:10 pm

#1762576

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