Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 33,136 through 33,150 (of 66,749 total)

You must be logged in to reply to this topic. Login to reply

Kiara SSCarpal Tunnel Points: 4185 More actions · Answer 1

GilaMonster (1/4/2012)
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)
What do you guys want to see an article on? (keep it to backups, database recovery, performance stuff)

How about something on table partitioning and performance? (I haven't checked your blog to see if you've already written something on this, so if you have, my apologies in advance...)

-Ki

Brandie Tarvin SSC Guru Points: 173083 More actions · Answer 2

GilaMonster (1/4/2012)
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)
What do you guys want to see an article on? (keep it to backups, database recovery, performance stuff)

What about something on SQL Server and the new deduplication backup technology?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Kiara (1/4/2012)
GilaMonster (1/4/2012)
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)
What do you guys want to see an article on? (keep it to backups, database recovery, performance stuff)
How about something on table partitioning and performance? (I haven't checked your blog to see if you've already written something on this, so if you have, my apologies in advance...)

I haven't and partitioning is something I've been playing with recently.

Thing is, partitioning is not generally about query performance (maybe extreme cases off multiple disks when the data's not cached, but that's not something I can repo at home)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Kiara SSCarpal Tunnel Points: 4185 More actions · Answer 4

GilaMonster (1/4/2012)
Kiara (1/4/2012)
GilaMonster (1/4/2012)
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)
What do you guys want to see an article on? (keep it to backups, database recovery, performance stuff)
How about something on table partitioning and performance? (I haven't checked your blog to see if you've already written something on this, so if you have, my apologies in advance...)
I haven't and partitioning is something I've been playing with recently.
Thing is, partitioning is not generally about query performance (maybe extreme cases off multiple disks when the data's not cached, but that's not something I can repo at home)

It's often touted as a way to improve performance though, for larger data sets, isn't it? (I haven't dug into it much yet, hence the interest - I have some reasonably large tables and users who like to query lots of data across them, and have been told that this will help the situation. But I haven't tested this yet, so don't know...)

-Ki

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Kiara (1/4/2012)
It's often touted as a way to improve performance though, for larger data sets, isn't it?

It is, but then people tout Nolock as a performance improvement and shrink as a required maintenance option and Truncate_Only as a log management technique.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Brandie Tarvin (1/4/2012)
GilaMonster (1/4/2012)
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)
What do you guys want to see an article on? (keep it to backups, database recovery, performance stuff)
What about something on SQL Server and the new deduplication backup technology?

Since I have no idea what you're talking about, maybe you could write that article?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 7

Stefan Krzywicki (1/4/2012)
GilaMonster (1/4/2012)
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)
What do you guys want to see an article on? (keep it to backups, database recovery, performance stuff)
Performance stuff
Like the effect of a clustered index on a table for insertions.
Microsoft says it improves speed, but I think that's not true in certain situations, like if you're always inserting into an empty table.
So maybe an article on when performance improvement standards don't hold true?

I mention it only because I'm in the middle of testing something that it relates to. I've got 4 different queries that produce the same results and I'm populating 2 tables that are identical except one has a clustered index and one has no index. They're wiped at the beginning of every batch insert and I haven't seen much of a difference in performance between the tables. I've been running them nightly for around a month and there's little difference between the performance on the two tables regardless of data size. Then again, each batch is only between 20K and 500K rows.

I have another way to try the query and there are several indexes on the tables I query to produce this data set that I'd like to try, but I can't start playing with that until we finish getting our test environment set up.

Ah well. I'll keep testing. At least I'll get some answers for my particular environment/data size.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 8

Kiara (1/4/2012)
GilaMonster (1/4/2012)
Speaking of articles, I'm getting the urge to write something again (yeah, I know...)
What do you guys want to see an article on? (keep it to backups, database recovery, performance stuff)
How about something on table partitioning and performance? (I haven't checked your blog to see if you've already written something on this, so if you have, my apologies in advance...)

I'm about half way through writing an article on partitioning and some of the pitfalls you'll encounter when implementing it, but I keep finding more that I need to mention. It isn't straightforward at all.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

Kiara (1/4/2012)
It's often touted as a way to improve performance though, for larger data sets, isn't it?

Have a read through this: http://msdn.microsoft.com/en-us/library/ms345146.aspx

There are performance benefits in some situations, but they're not automatic just because the table is partitioned.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 10

GilaMonster (1/4/2012)
Kiara (1/4/2012)
It's often touted as a way to improve performance though, for larger data sets, isn't it?
Have a read through this: http://msdn.microsoft.com/en-us/library/ms345146.aspx
There are performance benefits in some situations, but they're not automatic just because the table is partitioned.

The biggest benefit is being able to easily offload old data to archive tables, but even there you have to partition properly and frequently or just creating the partitions can be a problem if you don't have a large maintenance window.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 11

Stefan Krzywicki (1/4/2012)
GilaMonster (1/4/2012)
Kiara (1/4/2012)
It's often touted as a way to improve performance though, for larger data sets, isn't it?
Have a read through this: http://msdn.microsoft.com/en-us/library/ms345146.aspx
There are performance benefits in some situations, but they're not automatic just because the table is partitioned.
The biggest benefit is being able to easily offload old data to archive tables, but even there you have to partition properly and frequently or just creating the partitions can be a problem if you don't have a large maintenance window.

Probably more common with Data Warehousing and ETL.

Commonly used both for the offload, but also as a new swappable partition.

Partitioning is generally an Enterprise feature too.

Kiara SSCarpal Tunnel Points: 4185 More actions · Answer 12

GilaMonster (1/4/2012)
Kiara (1/4/2012)
It's often touted as a way to improve performance though, for larger data sets, isn't it?
It is, but then people tout Nolock as a performance improvement and shrink as a required maintenance option and Truncate_Only as a log management technique.

LOL - fair enough! I haven't done anything with it yet, so I have no idea whether or not it actually works!

-Ki

Kiara SSCarpal Tunnel Points: 4185 More actions · Answer 13

GilaMonster (1/4/2012)
Kiara (1/4/2012)
It's often touted as a way to improve performance though, for larger data sets, isn't it?
Have a read through this: http://msdn.microsoft.com/en-us/library/ms345146.aspx
There are performance benefits in some situations, but they're not automatic just because the table is partitioned.

Thanks - will do!

-Ki

Koen Verbeeck SSC Guru Points: 259125 More actions · Answer 14

Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)

Did I miss anything important?

(no, pants jokes are not important)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

GSquared SSC Guru Points: 260824 More actions · Answer 15

Koen Verbeeck (1/4/2012)
Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)
Did I miss anything important?
(no, pants jokes are not important)

Congratulations!

No, you didn't miss anything anywhere near so important as what you missed it for.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon