Jeff Moden

Forum Replies Created

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

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
RE: SQL DBA high ended question (5+ years’ experience)

Ed Wagner (8/6/2014)
How about a very simple one?
Please write the T-SQL code to count from 1 to 10.
There are many correct answers and how they answer can tell you 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)

August 6, 2014 at 11:44 am

#1735727
RE: Getting It Right First Time. Almost?

Here's a place where it would appear that most people still suffer "getting it right the first time".
http://news.msn.com/science-technology/report-russian-hackers-steal-12b-passwords
--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 am

#1735592
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Jason-368451 (8/6/2014)
I have a CSV file that I bulk loaded into a single column staging table.
I need a way to parse proper csv files that are comma delimited with...
--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:51 am

#1735587

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