Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 10,666 through 10,680 (of 66,815 total)

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

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 1

I havent tried it yet. I will try it next time... :hehe:

-Roy

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 2

Lynn Pettis (1/19/2010)
Oh, there is a way to update the system tables in SQL Server 2005, here's how. Let us know if it works for you. No warning about NOT doing it. Great Advice, heh?

Well, there is a way, but that's not it. Besides, I really doubt that UPDATE sysdatabases has ever been the appropriate way to enable torn page protection.

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

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

GilaMonster (1/19/2010)
Lynn Pettis (1/19/2010)
Oh, there is a way to update the system tables in SQL Server 2005, here's how. Let us know if it works for you. No warning about NOT doing it. Great Advice, heh?
Well, there is a way, but that's not it. Besides, I really doubt that UPDATE sysdatabases has ever been the appropriate way to enable torn page protection.

Oh, is that what he wants? Isn't that set using database properties? 😉

Luke L SSC-Dedicated Points: 35547 More actions · Answer 4

CirquedeSQLeil (1/19/2010)
That is so much harder to do with wife, children, and in-laws 😉

Wife, difficult perhaps

children... there's that whole teach a man to fish thing

in-laws, tell them their rate is $300/hr. but for them you'll drop it to $200. Or there's always the I'm sorry I don't like to mix work with pleasure. Here's the phone number for the local Geek Squad. I'm sure they'll be happy to help.

To help us help you read this[/url]For better help with performance problems please read this[/url]

SQLRNNR SSC Guru Points: 281344 More actions · Answer 5

Luke L (1/19/2010)
CirquedeSQLeil (1/19/2010)
That is so much harder to do with wife, children, and in-laws 😉
Wife, difficult perhaps
children... there's that whole teach a man to fish thing
in-laws, tell them their rate is $300/hr. but for them you'll drop it to $200. Or there's always the I'm sorry I don't like to mix work with pleasure. Here's the phone number for the local Geek Squad. I'm sure they'll be happy to help.

LOL

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

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

Lynn Pettis (1/19/2010)
GilaMonster (1/19/2010)
Well, there is a way, but that's not it. Besides, I really doubt that UPDATE sysdatabases has ever been the appropriate way to enable torn page protection.
Oh, is that what he wants? Isn't that set using database properties? 😉

That's what State 16 in sysdatabases is. Of course, since it's a bitmask column, updating it to 16 sets torn page on and unsets all the other options

Usually alter database is used to do that. It does tend to work slightly better than the direct update.

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

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

GilaMonster (1/19/2010)
Lynn Pettis (1/19/2010)
GilaMonster (1/19/2010)
Well, there is a way, but that's not it. Besides, I really doubt that UPDATE sysdatabases has ever been the appropriate way to enable torn page protection.
Oh, is that what he wants? Isn't that set using database properties? 😉
That's what State 16 in sysdatabases is. Of course, since it's a bitmask column, updating it to 16 sets torn page on and unsets all the other options
Usually alter database is used to do that. It does tend to work slightly better than the direct update.

Considering that updating the system table probably wouldn't change any settings on the actual database. There is probably something in the system data stored in the mdf as well. Is that a fair assumption or am I blowing smoke?

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 8

Lynn Pettis (1/19/2010)
Considering that updating the system table probably wouldn't change any settings on the actual database. There is probably something in the system data stored in the mdf as well. Is that a fair assumption or am I blowing smoke?

Probably not. Can't say for sure.

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

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

Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64) under SQL Server 2008 EE. One of the servers needs to link to a MySQL database. Okay, no problem, download the 5.01 driver, install it, and setup the Linked Server. PeopleSoft Admin tries creating one of the views used to access data from teh MySQL Database, error.

Okay, I start playing with the various settings (no real doc to help me here) and I can make things worse, but not better. That's okay, I start looking for an x64 version of the 3.51 driver (we are using the x32 version of this driver in production currently).

I think I find it, but I have figure out how it install it manually. Haven't done that in a while, so taking my time reading all that I can find (which is very little).

Get an email today from Sun thanking me for my interest in MySQL and if I need anything let them know. I reply saying my only interest is in connecting my SQL Server 2008 database servers to a vendor product that happens to use MySQL for their backend. Explain briefly the problem and what I am doning. I get a reply, full of links to resources including demos, webinars, a TCO Calculator, clustering, but nothing about their ODBC drivers.

Just great, thanks for the support. 😛

SQLRNNR SSC Guru Points: 281344 More actions · Answer 10

Did I read somewhere that Toshiba and Sun were joining forces?

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

Luke L SSC-Dedicated Points: 35547 More actions · Answer 11

Lynn Pettis (1/19/2010)
Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64) under SQL Server 2008 EE. One of the servers needs to link to a MySQL database. Okay, no problem, download the 5.01 driver, install it, and setup the Linked Server. PeopleSoft Admin tries creating one of the views used to access data from teh MySQL Database, error.
Okay, I start playing with the various settings (no real doc to help me here) and I can make things worse, but not better. That's okay, I start looking for an x64 version of the 3.51 driver (we are using the x32 version of this driver in production currently).
I think I find it, but I have figure out how it install it manually. Haven't done that in a while, so taking my time reading all that I can find (which is very little).
Get an email today from Sun thanking me for my interest in MySQL and if I need anything let them know. I reply saying my only interest is in connecting my SQL Server 2008 database servers to a vendor product that happens to use MySQL for their backend. Explain briefly the problem and what I am doning. I get a reply, full of links to resources including demos, webinars, a TCO Calculator, clustering, but nothing about their ODBC drivers.
Just great, thanks for the support. 😛

At least you didn't get something along the lines of "Why not try Oracle? It works great for this." 😉

edit: fixed the quote...

To help us help you read this[/url]For better help with performance problems please read this[/url]

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

CirquedeSQLeil (1/19/2010)
Did I read somewhere that Toshiba and Sun were joining forces?

I think that is fallback option if the EU decides Oracle and Sun shouldn't merge. 😉

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 13

CirquedeSQLeil (1/19/2010)
Did I read somewhere that Toshiba and Sun were joining forces?

I haven't heard that, but there was some talk about ASUS might be thinking about aquiring Toshiba.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Luke L (1/19/2010)
Lynn Pettis (1/19/2010)
Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64) under SQL Server 2008 EE. One of the servers needs to link to a MySQL database. Okay, no problem, download the 5.01 driver, install it, and setup the Linked Server. PeopleSoft Admin tries creating one of the views used to access data from teh MySQL Database, error.
Okay, I start playing with the various settings (no real doc to help me here) and I can make things worse, but not better. That's okay, I start looking for an x64 version of the 3.51 driver (we are using the x32 version of this driver in production currently).
I think I find it, but I have figure out how it install it manually. Haven't done that in a while, so taking my time reading all that I can find (which is very little).
Get an email today from Sun thanking me for my interest in MySQL and if I need anything let them know. I reply saying my only interest is in connecting my SQL Server 2008 database servers to a vendor product that happens to use MySQL for their backend. Explain briefly the problem and what I am doning. I get a reply, full of links to resources including demos, webinars, a TCO Calculator, clustering, but nothing about their ODBC drivers.
Just great, thanks for the support. 😛
At least you didn't get something along the lines of "Why not try Oracle? It works great for this." 😉
edit: fixed the quote...

My reply to that would be "We are a school district, we can't even afford to spell ORACLE, let alone run it." 😛

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

Lynn Pettis (1/19/2010)
My reply to that would be "We are a school district, we can't even afford to spell ORACLE, let alone run it." 😛

ooh, that's not going to help your test scores if your kids can't spell O-R-A-C-L-E... :hehe:

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