Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,996 through 23,010 (of 59,102 total)

RE: CLR Triggers on SQL 2008 R2 // Disable vs. Drop

sgmunson (8/8/2014)
Gail Shaw? Jeff Moden? Anyone?
To the best of my knowledge, dropping a trigger doesn't drop the underlying DDL but I'm no CLR guru, 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)

August 8, 2014 at 9:01 am

#1736451
RE: Table Partitioning Question

alex_pixley (8/7/2014)
GilaMonster (8/7/2014)
If partitions 8-13 are empty, this will not save you any disk space.
It's like insulating your home. There is the upfront cost of time and effort. ...
--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 7, 2014 at 6:54 pm

#1736261
RE: Create Clustered Index on a Very Large Table (500 GB)

MMartin1 (8/7/2014)
Jeff, I wanted to get your take on something Gail posted once :
http://www.sqlservercentral.com/Forums/FindPost485499.aspx
The way I read it, a clustered index (pk or not) won't necessarily cause a huge slowdown...
--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 7, 2014 at 6:36 pm

#1736259
RE: Table size is Huge!!!

smtzac (8/7/2014)
Sorry guys for late response. Not sure what is this table created for . I have scripted out:
CREATE TABLE [dbo].[ABCD](
[A] [uniqueidentifier] NULL,
[uniqueidentifier] NULL,
[C] [nvarchar](100) NULL,
[D] [nvarchar](max) NULL,
[E] [nvarchar](max)...
--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 7, 2014 at 9:09 am

#1736029
RE: Table size is Huge!!!

mssqlsrv (8/6/2014)
You can create Server and database audit to check what and who is inserting records in a table.
Also if possible use partitions for performance.
Oh, be careful now... partitioning won't...
--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 7, 2014 at 6:13 am

#1735933
RE: Table Partitioning Question

alex_pixley (8/6/2014)
I've inherited a database that primarily houses imports from an external source. The Trx_Header table is a normal table, but Trx_Details is partitioned by year. There are...
--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 7, 2014 at 5:52 am

#1735924
RE: Table Partitioning Question

mssqlsrv (8/7/2014)
Pls check on below link. Might be helpful.
http://www.patrickkeisler.com/2013/01/how-to-remove-undo-table-partitioning.html
I wouldn't remove table partitioning... it's not the problem and "undoing" partitioning won't save much space at all and will only undo...
--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 7, 2014 at 5:45 am

#1735922
RE: Create Flat Record From Multiple Results (TSQL)

TSQL_Newbie (8/7/2014)
Good Morning,
Sorry I am quite new to TSQL Query and require a little help if possible please.
I have obtained my results from a query from joining various tables 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)

August 7, 2014 at 5:37 am

#1735921
RE: Display ALL rows even if no data exists

To add to what Lutz posted, you have things like the following in your code...
WHEN mo.OFFICE_CD IN ('KBE ANR','KBE ZEE', 'KEU ANR') THEN 'BELGIUM'
It would be MUCH better if you...
--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 7, 2014 at 5:35 am

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

Sean Lange (8/6/2014)
Jeff Moden (8/5/2014)
rajeshn29.dba (8/5/2014)
Hi Friends,
I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for curiosity...
--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 6, 2014 at 6:12 pm

#1735818
RE: Table size is Huge!!!

smtzac (8/6/2014)
Thank you guys for your time 🙂
Since we have no clue what the table is actually being used for, we're just shooting in the dark. Take some time...
--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 6, 2014 at 5:58 pm

#1735817
RE: Table size is Huge!!!

GPO (8/6/2014)
I'm surprised nobody has discussed normalization... or did I miss something? It would be good if @smtzac could script the CREATE TABLE and tell us a bit 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 6, 2014 at 5:41 pm

#1735816
RE: Table size is Huge!!!

smtzac (8/6/2014)
Thank you guys for your time 🙂
You still haven't identified whether or not it's an audit table. If it is, a whole 'nuther world can be opened 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)

August 6, 2014 at 12:51 pm

#1735751
RE: Estimated time to complete the query.

samking (8/6/2014)
Hi friends,
I am running an update query.
It is taking long time. To find the estimated completion time i checked sys.dm_exec_request or sys.dm_exec_session or sp_who2 but there is no clue....
--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 6, 2014 at 11:58 am

#1735733
RE: how to speed up update statistics full scan

rajsin7786 (8/6/2014)
hi,
i have a 20G table which takes 40 minutes to update statistics with full scan.
i want to perform update statistics with full scan on a 350 GB table. ...
--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 6, 2014 at 11:53 am

#1735730

Viewing 15 posts - 22,996 through 23,010 (of 59,102 total)