Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,496 through 21,510 (of 59,098 total)

RE: You have a SQL Server stored procedure named...

Actually, none of the answers are correct. Even if you take the correct action according to the answers provided, it is possible that the proc won't auto run on...
--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)

February 21, 2015 at 6:16 pm

#1779130
RE: SQL Server 2012 - Transaction log growth

s*1918 (2/20/2015)
I have DB which is set to Full recovery model and looks like the current transaction log file size is 330GB. The transaction log file is growth is increasing...
--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)

February 21, 2015 at 4:10 pm

#1779129
RE: Want to create random alphanumeric characters for primary key values

CELKO (2/20/2015)
I'm guessing he'll push that functionality out to the app server!
There's certainly a good argument that that is where the logic should be.
Here is the formula for 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)

February 21, 2015 at 4:01 pm

#1779128
RE: Why Sql doesn't use clustered index ?

farax_x (2/21/2015)
I have a table like this :
CREATE TABLE [dbo].[News_News](
[NewsId] [int] NOT NULL,
[Url] [nvarchar](4000) NOT NULL,
[Title] [nvarchar](4000) NOT NULL,
[Description] [nvarchar](4000) NULL,
[CreationDate] [datetime] NOT NULL,
[AgencyId] [int] NOT NULL,
[SCode] [varchar](6) NULL,
CONSTRAINT...
--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)

February 21, 2015 at 12:48 pm

#1779124
RE: How to calculate Difference

sm_iransoftware (2/20/2015)
I saved Table size in a log table .
Then now I have These records :
InfoDate ---- SizeMB ---- TableName
D1 ----------- 100 --------T1
D1 ----------- 250 --------T2...
--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)

February 21, 2015 at 9:20 am

#1779120
RE: PK v Unique Index

Eirikur Eiriksson (2/21/2015)
Jeff Moden (2/21/2015)
I guess my point is that while there is the difference in Nullability, an NC-PK isn't really going to have any I/O advantage over a Unique...
--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)

February 21, 2015 at 8:08 am

#1779117
RE: PK v Unique Index

I guess my point is that while there is the difference in Nullability, an NC-PK isn't really going to have any I/O advantage over a Unique NCI as the user...
--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)

February 21, 2015 at 7:26 am

#1779114
RE: How to use stuff function in this case

In case anyone is interested, I've corrected the previously faulty code as follows. I also tried to make it a little bit more readable.
SELECT a, b, stuff(
...
--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)

February 20, 2015 at 7:45 pm

#1779093
RE: How to use stuff function in this case

gautham.gn (10/15/2014)
Hi Guys,
This is how I achieved the result.
select a,b, stuff(
(select ', '+level1 from
(select a,b,c+'('+
stuff((select ', '+d from example with (nolock)
where a = x.a and b = x.b and...
--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)

February 20, 2015 at 7:09 pm

#1779091
RE: BCP reports no errors but inserts no rows

kevaburg (2/15/2015)
Can anyone help? I am losing more hair with each execution..... 🙂
Regards
Kev
I think Jim hit the nail on the head above.
Shifting gears a bit, is there...
--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)

February 20, 2015 at 6:44 pm

#1779089
RE: BCP reports no errors but inserts no rows

Jim Mackenzie (2/20/2015)
However I can't help but think this would be better handled in Powershell?
Do you happen to have a working example of such a thing? I'd love 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)

February 20, 2015 at 6:41 pm

#1779088
RE: decompress gzipped BLOB with MSSQL-SP

hurr1k4ne (2/20/2015)
why not let the app that's using the data warehouse do the unzipping on demand
Ah, okay got ya! That a good point on storage...
Because it is a data...
--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)

February 20, 2015 at 6:34 pm

#1779087
RE: PK v Unique Index

Steve Jones - SSC Editor (2/20/2015)
I user request to get an article, which would explain in details the differences between primary key and unique index, especially from disk i/o point...
--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)

February 20, 2015 at 6:18 pm

#1779086
RE: delete data from partitions - faster approach

Tara-1044200 (2/20/2015)
table partitioned by month
Understood that from your original post. There are two types of partitioning in SQL Server. One is known as "partitioned views", which works...
--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)

February 20, 2015 at 11:54 am

#1779034
RE: delete data from partitions - faster approach

Tara-1044200 (2/20/2015)
I am restoring a database with 10yrs worth of data which have monthly partitions but i would like to keep only 5yrs of data after the restore is done,...
--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)

February 20, 2015 at 10:29 am

#1779007

Viewing 15 posts - 21,496 through 21,510 (of 59,098 total)