Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,306 through 22,320 (of 59,072 total)

RE: Single Table Size is increasing....

If you check the results from the script I gave, there are 3,832,619 pages of LOB data present. If we multiply that times the page size of 8,192,...
--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)

November 30, 2014 at 10:57 pm

#1761595
RE: How to check which column is taking more space in a table?

Chowdary's (11/30/2014)
Hi Everyone..
One of the table is occupying more space.
how to check which column is taking more space in a table?
This is for the same problem that you're having...
--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)

November 30, 2014 at 10:24 pm

#1761593
RE: How to free up the drive space in SQL that has data files

WhiteLotus (11/30/2014)
Jeff Moden (11/28/2014)
A 1 TB 15k-RPM drive costs less than $300 for a SAN drive. For a local drive, you can get one for about $70. You've...
--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)

November 30, 2014 at 10:05 pm

#1761592
RE: Single Table Size is increasing....

Chowdary's (11/30/2014)
Hi everyone,
We are having the issue with DB size,
for every 3 months we are getting the same issue.
The thing is only one table getting increasing the size.
On 26th...
--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)

November 30, 2014 at 9:52 pm

#1761589
RE: SQLCMD :CONNECT Script Unable to Connect

No idea what the problem is but... I wouldn't use the SA login ever (most folks in-the-know will disable it on their servers) and I sure wouldn't embed the password...
--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)

November 30, 2014 at 9:08 pm

#1761588
RE: Today's Random Word!

Ed Wagner (11/30/2014)
SQLRNNR (11/29/2014)
Junk (ship)
Scuttle
Being a former submarine sailor, my word would be "target". 😛
--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)

November 30, 2014 at 7:01 pm

#1761586
RE: My Cursor don´t UPDATE

luissantos (11/30/2014)
Hello comunity
I found the problem and solve the situation because i not write the correct name field to Update.
the correct name is eftaxam_a and not ftaxamt_a.
my apologies.
Best regards,
Luis Santos
No...
--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)

November 30, 2014 at 5:31 pm

#1761579
RE: trying to find a more efficent way

aaron.reese (11/30/2014)
Normally running totals should be delegated to the reporting application; they infer a sequence which goes against Set Theory.
You've touch a "sweet" spot for me, Aaron. I have...
--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)

November 30, 2014 at 4:56 pm

#1761577
RE: Case Statment

ahfb (11/30/2014)
Hi all,
I want to write a Query For Table
CASE WHEN ISNUMERIC(PriceColumn) = 1 THEN CAST(PriceColumn AS DECIMAL(18,2)) ELSE 0 END
Error:
Error converting data type nvarchar to numeric
-------------------------------------
Some of Data in...
--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)

November 30, 2014 at 3:59 pm

#1761575
RE: How to create a database for school management .

Not to mention a "near campus" and one or more "home" addresses depending on whether Mom & Dad have a time share or not. In fact, you might want...
--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)

November 30, 2014 at 3:52 pm

#1761574
RE: How to create a database for school management .

arunnrj87 (11/30/2014)
Hi friends,
We got a new project and developer told to create a new database and told to design me.
They given the Details in Excel sheet which i have attachment...
--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)

November 30, 2014 at 10:37 am

#1761565
RE: How to get DATETIME number?

Heh... I definitely sympathize with that task. For me to get back down to what I once weighed, I'd have to loose the equivalent of a 9th grader. :pinch:...
--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)

November 30, 2014 at 10:19 am

#1761563
RE: Approach to archiving tables with foreign key constraints

p.s. I strongly recommend that you take a full backup of your test environment before you do any delete tests. If the delete tests don't work out right,...
--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)

November 30, 2014 at 10:12 am

#1761561
RE: Approach to archiving tables with foreign key constraints

Hi anni00,
On the surface, it would appear that way but, like everything else in SQL Server, it really does depend. DELETES can be brutal because a lot of people...
--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)

November 30, 2014 at 10:10 am

#1761560
RE: How to get DATETIME number?

Edvard Korsbæk (11/30/2014)
And how could i have found out without asking here....
There are a huge number of examples in "Books Online", affectionately and commonly referred to as just "BOL", which...
--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)

November 30, 2014 at 9:49 am

#1761559

Viewing 15 posts - 22,306 through 22,320 (of 59,072 total)