Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,946 through 30,960 (of 59,101 total)

RE: Need help finding out the space used by the table

SQLDBA ARJUN (2/29/2012)
You Can these scripts to find the table spaces on the server
SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count
FROM sys.dm_db_partition_stats st
WHERE index_id < 2
ORDER BY st.row_count DESC
GO
SELECT * FROM THOURS
SELECT...
--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 29, 2012 at 4:50 am

#1453061
RE: Whats the difference between jobs and maintenance plan??

Left over interview question.
http://www.sqlservercentral.com/Forums/Topic1258844-146-1.aspx
--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 28, 2012 at 11:08 pm

#1452921
RE: Need help finding out the space used by the table

I've not tried this in 2008, yet, but it did a dandy job in SQL Server 2005. A lot of the tables I referenced are legacy tables that 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)

February 28, 2012 at 11:03 pm

#1452919
RE: Erratic SP Performance

Dave Mason (2/28/2012)
One final update (for now)...
I rebooted the server during a maintenance window Monday night. Performance has resumed to normal. Users are no longer complaining, I can...
--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 28, 2012 at 10:58 pm

#1452918
RE: ALTER TABLES

http://www.google.com/#hl=en&output=search&sclient=psy-ab&q=basics+of+sql+server&fp=ff2755fb3b234393
--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 28, 2012 at 10:54 pm

#1452917
RE: Need answers for interview questions...

satishm94 (2/28/2012)
Hi.
actually i have 70 questions with me and i googled everything and foundout the answers..
and
i did found answers for some of the questions i posted but i didnt understand..
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 28, 2012 at 10:24 pm

#1452911
RE: Help with Logic

CELKO (2/28/2012)
Get a book on RDBMS and read the parts about keys and normalization. You have no key and more NULL-able columns than an entire schema. A since you 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 28, 2012 at 10:22 pm

#1452910
RE: poor performance running select on non indexed views

Mark Thornton (2/28/2012)
When running the entire process I was hoping for great results but after 45 minutes of processing it blew up tempdb. On the old sql 2000 server...
--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 28, 2012 at 10:13 pm

#1452909
RE: Macro like function in SQL

As a bit of a sidebar, thank you very much for the way you posted "readily consumable" data and expected results. It made it a whole lot easier for...
--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 28, 2012 at 9:56 pm

#1452904
RE: Macro like function in SQL

arpost (2/28/2012)
I have another question now. I was trying to use a CTE to come up with a way to create a field. Basically I want to create...
--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 28, 2012 at 9:54 pm

#1452903
RE: Macro like function in SQL

arpost (2/23/2012)
Thanks this is much better. And yeah in the end I need those 2 fields to be VARCHAR since I want to add one more value called 'Total'....
--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 28, 2012 at 9:16 pm

#1452898
RE: Macro like function in SQL

arthurolcot (2/23/2012)
I'm glad it helps and if you get stuck again then please post back on this thread and i'll be happy (or indeed others i'm sure) to try 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 28, 2012 at 8:55 pm

#1452896
RE: Getting two different rows as columns

dwain.c (2/28/2012)
Why not reverse the SELECT and avoid the INNER JOIN and GROUP BY by using sub-queries?
SELECT
T1.Name
,(SELECT t.TITLE FROM Test t WHERE t.id=1 and t.Name = t1.Name) AS Title
,(SELECT...
--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 28, 2012 at 8:51 pm

#1452895
RE: Are the posted questions getting worse?

Gianluca Sartori (2/28/2012)
Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than it used...
--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 28, 2012 at 8:19 pm

#1452887
RE: Dividing a list of filenames into roughly equal batch sizes in KB

Here's the result using the original data that Sean used. It's a bit different than the original posted desired result but it has the same effect... all of the...
--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 28, 2012 at 7:34 pm

#1452883

Viewing 15 posts - 30,946 through 30,960 (of 59,101 total)