Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,466 through 21,480 (of 59,072 total)

RE: Queries and Joining tables

spaghettidba (2/23/2015)
Highly debatable...
The ISO standards suggest that table names are pluralized. I admit that I agree with Celko on this one.
No problem... I don't follow those either. 😛
--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 23, 2015 at 1:01 pm

#1779395
RE: sp_Blitz Last good DBCC CHECKDB over 2 weeks old - tempdb

Ola Hallengren (2/23/2015)
In the latest version you can do like this:
EXECUTE dbo.DatabaseIntegrityCheck @Databases = 'SYSTEM_DATABASES,tempdb', @CheckCommands = 'CHECKDB'
Please send me a mail for more details.
Ola Hallengren
https://ola.hallengren.com
Rather than taking it offline,...
--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 23, 2015 at 9:42 am

#1779318
RE: Data insertion from staging table to main table.

Shifting gears a bit, the whole idea of a staging table is to pre-validate rows of data so that you don't end up with such a problem as rollbacks. ...
--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 23, 2015 at 9:12 am

#1779303
RE: Queries and Joining tables

Heh... table names as plural nouns. Makes for some interesting and non-automatable naming conventions.
So, let me ask... do you have an Employee table or an Employees table? Do...
--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 23, 2015 at 9:01 am

#1779299
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

Viewing 15 posts - 21,466 through 21,480 (of 59,072 total)