Survey Results - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

The Yak Corral

Survey Results

Author

Topic

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-10-12 : 16:11:30

Thanks to everyone who participated in the survey I posted earlier:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150851

The results as of today are here:

http://www.sqlteam.com/SurveyMonkey_SQLServer.htm

The survey is still open so you are free to answer if you haven't already...or flood it with responses to skew the results.

X002548
Not Just a Number

15586 Posts

Posted - 2010-10-12 : 16:42:04

hey I'm one of the 4 on host_name()

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2010-10-12 : 16:47:12

9.4% used Federated Servers?

That's a bit shocking. I never heard of anyone using Federated Servers, except maybe for a TPC test.

And 3.0% said there is no such thing as GETDATE()?

CODO ERGO SUM

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-10-13 : 02:34:47

The only thing really surprising to me was the that 59.4% (19) said that heap tables are both good and bad. What could possibly be good about heap tables??

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-10-13 : 04:42:49

quote:
Originally posted by X002548

hey I'm one of the 4 on host_name()

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

I'm one of the other 3..

I can't believe so few people use SUSER_SNAME(). Don't you want to know who is running something, Or are you simply not auditing properly?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-10-13 : 04:48:01

quote:
Originally posted by Lumbago

The only thing really surprising to me was the that 59.4% (19) said that heap tables are both good and bad. What could possibly be good about heap tables??

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

Yeah, and who is the person that thinks they are always a good idea?

Looking at the results as a whole, I think maybe some people didn't answer it seriously... I mean, who would think that using sa is always a good thing?

I would also like to know why the 6 people thought Table/Clustered Index scans were always a bad thing, I mean, what if you have a table with very few records, a scan would be faster?!?

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-10-13 : 04:49:11

quote:
I can't believe so few people use SUSER_SNAME(). Don't you want to know who is running something, Or are you simply not auditing properly?

We use sa for everything so there's no point

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-10-13 : 04:53:05

quote:
Originally posted by Lumbago

quote:
I can't believe so few people use SUSER_SNAME(). Don't you want to know who is running something, Or are you simply not auditing properly?
We use sa for everything so there's no point

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

I don't want to work where you do..

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-10-13 : 05:06:18

I should almost not joke about this. I was with a client not too long ago debugging some authentication problems between a new application server and a SQL 2005 server. After a bit of investigation I was kind of stumped because there were over 60 stand-alone app-servers (no domain) connecting to this db-server and all of them were able to connect just fine except this one server and they were all created from the same template. But the sql server was configured to accept windows auth only and I found it weird that all the servers still could connect. It was then I discovered that *all* the servers were connecting using the local administrator account and ALL of the administrator accounts had the same password!! The reason why this one server didn't work was because they had changed the admin account password in the template just recently... *shiver*

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

Kristen
Test

22859 Posts

Posted - 2010-10-13 : 07:00:43

"I can't believe so few people use SUSER_SNAME(). Don't you want to know who is running something, Or are you simply not auditing properly?"

We have only one login, from the web site, so we need to "discover" the user, for auditing, by some other means. Our user-column in our audit tables does default to SUSER_SNAME() and we have "dbo" values in there ... but its not much help! other than to tell us that someone did a manual T-SQL action and forgot to INSERT a value for the CreateUser column.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-10-13 : 07:18:17

I use SUSER_SNAME() more for the case of other developers/dbas changing data, its a blame mechanism..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources