Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 37,906 through 37,920 (of 66,712 total)

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

dwain.c (9/18/2012)
L' Eomot Inversé (9/18/2012)
Evil Kraig F (9/18/2012)
Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.
No, it doesn't. If I understand it correctly EXCEL 2007 and EXCEL 2010 both have a limit of 16,384 columns (but something over a million rows). With EXCEL 2010 you can populate a lot more of those cells in the 64-bit version than in the 32-bit version but that doesn't help if what you want is 150,000 columns.
You're forgetting that 150,000 columns can be put into 10 worksheets (15K at a time). 😀

Yes, of course. Why on earth did I reject that approach? :hehe:

In fact I guess I could even do it with my faithful old Office 2000, using 586 worksheets. 🙂

Now, where did I put that Office 2000 CD? :w00t:

Tom

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 2

L' Eomot Inversé (9/18/2012)
Evil Kraig F (9/18/2012)
Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.
No, it doesn't. If I understand it correctly EXCEL 2007 and EXCEL 2010 both have a limit of 16,384 columns (but something over a million rows). With EXCEL 2010 you can populate a lot more of those cells in the 64-bit version than in the 32-bit version but that doesn't help if what you want is 150,000 columns.

1,048,576 rows by 16,384 columns according to MS Office site. Didn't someone say that the PowerPivot example at PASS a year or two back was running 11 million rows? How did they accomplish that?

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

jcrawf02 (9/19/2012)
L' Eomot Inversé (9/18/2012)
Evil Kraig F (9/18/2012)
Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.
No, it doesn't. If I understand it correctly EXCEL 2007 and EXCEL 2010 both have a limit of 16,384 columns (but something over a million rows). With EXCEL 2010 you can populate a lot more of those cells in the 64-bit version than in the 32-bit version but that doesn't help if what you want is 150,000 columns.
1,048,576 rows by 16,384 columns according to MS Office site. Didn't someone say that the PowerPivot example at PASS a year or two back was running 11 million rows? How did they accomplish that?

PowerPivot is not the same as Excel.

The PowerPivot window (where you make the model), has the 11 million rows. In Excel you just pivot over those rows. That's the reason PowerPivot doesn't support drillthrough, as you cannot drillthrough more than one million rows in Excel.

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

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

Koen Verbeeck (9/19/2012)
jcrawf02 (9/19/2012)
L' Eomot Inversé (9/18/2012)
Evil Kraig F (9/18/2012)
Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.
No, it doesn't. If I understand it correctly EXCEL 2007 and EXCEL 2010 both have a limit of 16,384 columns (but something over a million rows). With EXCEL 2010 you can populate a lot more of those cells in the 64-bit version than in the 32-bit version but that doesn't help if what you want is 150,000 columns.
1,048,576 rows by 16,384 columns according to MS Office site. Didn't someone say that the PowerPivot example at PASS a year or two back was running 11 million rows? How did they accomplish that?
PowerPivot is not the same as Excel.
The PowerPivot window (where you make the model), has the 11 million rows. In Excel you just pivot over those rows. That's the reason PowerPivot doesn't support drillthrough, as you cannot drillthrough more than one million rows in Excel.

PowerPivot can handle upwards of 100M rows.

And Excel 2010 1.4M rows.

PowerPivot is an add in to Excel, and there is also a server product that can be used with SharePoint 2010.

Part of what it can handle is based on how you are using it, whether standalone or with a data model deployed to the server.

More options, although there are some differences between PowerPivot and the more traditional Pivot Tables.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 5

Nothing wrong with this maintenance plan. I mean, everything is covered:

1. Check DB Integrity

2. Back Up Db Full

3. Back up Db transaction log

4. Shrink Db

5. Rebuild index

6. Update statistics

7. Reorganize Index

8. Clean up history

9. maintenace clean up task ( which will dlete the .bak and .trn files which are older than 3 days.

Face.... palm... repeat vigorously.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 6

Grant Fritchey (9/19/2012)
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize Index
8. Clean up history
9. maintenace clean up task ( which will dlete the .bak and .trn files which are older than 3 days.
Face.... palm... repeat vigorously.

I don't see what the problem is. At least the kitchen sink isn't included. Or the baby & bathwater.

or https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png if your browser doesn't let you see the image directly.

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.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 7

Brandie Tarvin (9/19/2012)
Grant Fritchey (9/19/2012)
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize Index
8. Clean up history
9. maintenace clean up task ( which will dlete the .bak and .trn files which are older than 3 days.
Face.... palm... repeat vigorously.
I don't see what the problem is. At least the kitchen sink isn't included. Or the baby & bathwater.
or https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png if your browser doesn't let you see the image directly.

Well, they've only been shrinking the database nightly for three months running...

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

jasona.work SSC Guru Points: 50117 More actions · Answer 8

Grant Fritchey (9/19/2012)
Brandie Tarvin (9/19/2012)
Grant Fritchey (9/19/2012)
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize Index
8. Clean up history
9. maintenace clean up task ( which will dlete the .bak and .trn files which are older than 3 days.
Face.... palm... repeat vigorously.
I don't see what the problem is. At least the kitchen sink isn't included. Or the baby & bathwater.
or https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png if your browser doesn't let you see the image directly.
Well, they've only been shrinking the database nightly for three months running...

I'll be honest, at one time, I would have made a maintenance plan similar to that. Worse, I'd have the cleanup looking for .bak / .trn, so it actually wouldn't clean up anything.

It's one of those things that (obviously) comes from experience. Sure, if you've been doing this for years, and know better, it can be frustrating to deal with someone who thinks this is "right," but give them credit for trying.

At least they weren't running it hourly, right?:hehe:

Jason

(OK, I'm tired, and feeling noob-ish this morning, maybe that's why I'm jumping to the defense...)

Thomas Rushton SSC-Insane Points: 22649 More actions · Answer 9

The perp still hasn't answered the big "Why" question...

Thomas Rushton
blog: https://thelonedba.wordpress.com

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 10

Grant Fritchey (9/19/2012)
Brandie Tarvin (9/19/2012)
Grant Fritchey (9/19/2012)
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize Index
8. Clean up history
9. maintenace clean up task ( which will dlete the .bak and .trn files which are older than 3 days.
Face.... palm... repeat vigorously.
I don't see what the problem is. At least the kitchen sink isn't included. Or the baby & bathwater.
or https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png if your browser doesn't let you see the image directly.
Well, they've only been shrinking the database nightly for three months running...

But surely shrinking the database is necessary. You know, to reclaim all that space that autogrow keeps claiming when it doesn't actually need it.

And that reminds me. I keep forgetting to turn on auto_close. @=)

(and, yes, I am actually joking).

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.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 11

Grant Fritchey (9/19/2012)
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize Index
8. Clean up history
9. maintenace clean up task ( which will dlete the .bak and .trn files which are older than 3 days.
Face.... palm... repeat vigorously.

At least the shrink is before the rebuild.

Paul White SSC Guru Points: 150467 More actions · Answer 12

Grant Fritchey (9/19/2012)
Nothing wrong with this maintenance plan. I mean, everything is covered:

Maintenance window must have been around 23 hours daily 🙂

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Grant Fritchey (9/19/2012)
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize Index
8. Clean up history
9. maintenace clean up task ( which will dlete the .bak and .trn files which are older than 3 days.
Face.... palm... repeat vigorously.

I just encountered two doing the exact same thing - both on the same server running at the same time...:crazy:

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

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

SQLRNNR (9/19/2012)
Grant Fritchey (9/19/2012)
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize Index
8. Clean up history
9. maintenace clean up task ( which will dlete the .bak and .trn files which are older than 3 days.
Face.... palm... repeat vigorously.
I just encountered two doing the exact same thing - both on the same server running at the same time...:crazy:

Now THAT is thorough!

--------------------------------------
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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 15

Stefan Krzywicki (9/19/2012)
SQLRNNR (9/19/2012)
Grant Fritchey (9/19/2012)
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize Index
8. Clean up history
9. maintenace clean up task ( which will dlete the .bak and .trn files which are older than 3 days.
Face.... palm... repeat vigorously.
I just encountered two doing the exact same thing - both on the same server running at the same time...:crazy:
Now THAT is thorough!

I'm sorry, but is there a specific thread where this is happening?