Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 17,551 through 17,565 (of 66,815 total)

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

SQLRNNR SSC Guru Points: 281344 More actions · Answer 1

Alvin Ramard (8/17/2010)
Jason, with 25 GB of storage space you could leave it there for a fairly long time.

In compressed form - a considerably long time. Uncompressed streaming video - 75 months.

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

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

CirquedeSQLeil (8/17/2010)
Alvin Ramard (8/17/2010)
Jason, with 25 GB of storage space you could leave it there for a fairly long time.
In compressed form - a considerably long time. Uncompressed streaming video - 75 months.

RATS!!! Only 75 months? Wait!!! That space is likely to get bigger during that time period. 🙂

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]

SQLRNNR SSC Guru Points: 281344 More actions · Answer 3

[qu:-D:-D:-D:-D:-Dote]Alvin Ramard (8/17/2010)

CirquedeSQLeil (8/17/2010)
Alvin Ramard (8/17/2010)
Jason, with 25 GB of storage space you could leave it there for a fairly long time.
In compressed form - a considerably long time. Uncompressed streaming video - 75 months.

RATS!!! Only 75 months? Wait!!! That space is likely to get bigger during that time period. :-)[/quote]

:-D:-D:-D:-D:-D

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

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

CirquedeSQLeil (8/17/2010)
[qu:-D:-D:-D:-D:-Dote]Alvin Ramard (8/17/2010)
CirquedeSQLeil (8/17/2010)
Alvin Ramard (8/17/2010)
Jason, with 25 GB of storage space you could leave it there for a fairly long time.
In compressed form - a considerably long time. Uncompressed streaming video - 75 months.
RATS!!! Only 75 months? Wait!!! That space is likely to get bigger during that time period. 🙂

:-D:-D:-D:-D:-D[/quote]

You misquoted me. (Yes, pun intended!) 😛

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]

WayneS SSC Guru Points: 95461 More actions · Answer 5

jcrawf02 (8/12/2010)
I'm sure that I read someone's blog/article about how table variables can be indexed during the declaration of the variable, and I think it was outside even of a primary key, but I can't find it anywhere. Anybody remember that/know where I could find it?
Found this, which is similar, but not exactly what I remembered.
Thx

Just got back from a long weekend. Don't know if you got a better answer yet... have you looked at this article?[/url]

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281344 More actions · Answer 6

I blame that misquote entirely on the computer.:cool:

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

WayneS SSC Guru Points: 95461 More actions · Answer 7

Gianluca Sartori (8/12/2010)
Paul White NZ (8/12/2010)
David Benoit (8/12/2010)
Paul White NZ (8/12/2010)
You can name constraints on # and ## temporary tables, but it is a pretty bad idea.
I haven't had a need to do this (or even consider it yet) but wondering what makes it a "bad idea"? Thanks in advance for the knowledge share.
A constraint name is scoped to the database, but # and ## tables are all created in the same database: tempdb.
Because # and ## tables can be created independently on more than one connection, this can lead to a name collision.
Try running the following code from two separate connections to the same server:
CREATE TABLE #temp (a INTEGER NOT NULL CONSTRAINT pk_temp PRIMARY KEY);
You'll get an error on the second connection:
.Net SqlClient Data Provider: Msg 2714, Level 16, State 4, Line 1
There is already an object named 'pk_temp' in the database.
.Net SqlClient Data Provider: Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
It could get even more confusing, if you like:
IF OBJECT_ID('tempdb..#temp') IS NOT NULL
DROP TABLE #temp
CREATE TABLE #temp (a INTEGER NOT NULL PRIMARY KEY);
INSERT INTO #temp VALUES (0);
EXECUTE('SELECT * FROM #temp;
CREATE TABLE #temp (b char(2) NOT NULL PRIMARY KEY);
INSERT INTO #temp VALUES (''AA'');
SELECT * FROM #temp;')
Output:
a
-----------
0
b
----
AA
Nice, isn't it?

What's really nice is that in the second (dynamic sql) select, since there are > 1 temp table available to that connection with that name, it is not guaranteed which one of the temp tables that the results will be returned from. IMO, it should be the last created one by that connection.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95461 More actions · Answer 8

CirquedeSQLeil (8/13/2010)
Brandie Tarvin (8/13/2010)
CirquedeSQLeil (8/13/2010)
Nothing like coming in to work to find out that the server team deployed patches to production boxes, caused an outage, didn't communicate that fact, and did not follow process and agreed upon schedule.
I see your out of hours outage and raise you a "non-emergency patch install and server reboot in the middle of the business day instead of during the usual maintenance window," Sir.
It didn't happen today, but it did happen.
I would not be a happy camper.

Which brings up a question: How do you'll handle it when things like this are done to the database servers you're responsible for?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281344 More actions · Answer 9

WayneS (8/17/2010)
CirquedeSQLeil (8/13/2010)
Brandie Tarvin (8/13/2010)
CirquedeSQLeil (8/13/2010)
Nothing like coming in to work to find out that the server team deployed patches to production boxes, caused an outage, didn't communicate that fact, and did not follow process and agreed upon schedule.
I see your out of hours outage and raise you a "non-emergency patch install and server reboot in the middle of the business day instead of during the usual maintenance window," Sir.
It didn't happen today, but it did happen.
I would not be a happy camper.
Which brings up a question: How do you'll handle it when things like this are done to the database servers you're responsible for?

I find out who did it and have a chat with them. I give them an opportunity to explain and then civilly request that they at least notify me if they plan to do something of that sort again.

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

WayneS SSC Guru Points: 95461 More actions · Answer 10

CirquedeSQLeil (8/17/2010)
WayneS (8/17/2010)
Which brings up a question: How do you'll handle it when things like this are done to the database servers you're responsible for?
I find out who did it and have a chat with them. I give them an opportunity to explain and then civilly request that they at least notify me if they plan to do something of that sort again.

I'm afraid I'd be offering to add an appendage, complete with their shoe, to their rear end if they ever did that again.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SQLRNNR SSC Guru Points: 281344 More actions · Answer 11

WayneS (8/17/2010)
CirquedeSQLeil (8/17/2010)
WayneS (8/17/2010)
Which brings up a question: How do you'll handle it when things like this are done to the database servers you're responsible for?
I find out who did it and have a chat with them. I give them an opportunity to explain and then civilly request that they at least notify me if they plan to do something of that sort again.
I'm afraid I'd be offering to add an appendage, complete with their shoe, to their rear end if they ever did that again.

Heh, it takes restraint and maybe a short walk or something. I make sure they understand that it ticked me off pretty good. But at that point it is something that has already been done, I have had to do something to fix it, and now it is just a matter of clearing the air.

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

Jeff Moden SSC Guru Points: 1004639 More actions · Answer 12

jcrawf02 (8/17/2010)
Jeff Moden (8/17/2010)
jcrawf02 (8/17/2010)
speaking of which, anybody used yuuguu before? supposedly the presenter installs, and the audience doesn't have to do anything to view the presentation, not sure 'zackly how that works, trying it out tonight.
Sounds promising and just right. Do you have a URL for that, Jon?
Since I will never again get this opportunity.....http://www.lmgtfy.com/?q=yuuguu
:w00t::-D:hehe:

BWAA-HAAA!!!! Yeah, I guess I had that coming for sure. 🙂 Oddly enough, though, I'm still not the one that had to look it up. :w00t: Thanks, Jon.

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

Jeff Moden SSC Guru Points: 1004639 More actions · Answer 13

Alvin Ramard (8/17/2010)
jcrawf02 (8/17/2010)
Jeff Moden (8/17/2010)
jcrawf02 (8/17/2010)
speaking of which, anybody used yuuguu before? supposedly the presenter installs, and the audience doesn't have to do anything to view the presentation, not sure 'zackly how that works, trying it out tonight.
Sounds promising and just right. Do you have a URL for that, Jon?
Since I will never again get this opportunity.....http://www.lmgtfy.com/?q=yuuguu
:w00t::-D:hehe:
Well done!!!!!!
:-D:hehe::-P:hehe::-D:hehe::-P:hehe::-D:hehe:

Heh... imagine that... a chipmunk that likes pork chops! :hehe:

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

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

Jeff Moden (8/17/2010)
Alvin Ramard (8/17/2010)
jcrawf02 (8/17/2010)
Jeff Moden (8/17/2010)
jcrawf02 (8/17/2010)
speaking of which, anybody used yuuguu before? supposedly the presenter installs, and the audience doesn't have to do anything to view the presentation, not sure 'zackly how that works, trying it out tonight.
Sounds promising and just right. Do you have a URL for that, Jon?
Since I will never again get this opportunity.....http://www.lmgtfy.com/?q=yuuguu
:w00t::-D:hehe:
Well done!!!!!!
:-D:hehe::-P:hehe::-D:hehe::-P:hehe::-D:hehe:
Heh... imagine that... a chipmunk that likes pork chops! :hehe:

As I was saying, I like my pork chops well done. 😀

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]

Jeff Moden SSC Guru Points: 1004639 More actions · Answer 15

jcrawf02 (8/17/2010)
I actually like livemeeting, works better than some of the others I've been involved with, especially for feedback during the meeting (status color thingy) meetingplace and webex are the ones I've used specifically. We even have Telepresence units installed here at work, think $10,000 web cams. ridiculous.
Anyhoo, I was really hoping your session would make Community Choice Jeff, sorry that it didn't. I think I got 3 out of 4, but can't remember if I voted for one of them or not, since I liked several sessions in the BI section.
and I gotta say, I was tempted to vote for Sean's session strictly because of the title, nothing more. Made me laugh out loud while I was voting.

The folks in our local PASS group use LiveMeeting, as well. It does some funny stuff to PPT presentations. Screws up the font, etc.

On the Community Choice thing... absolutely no worries. I'm surprised that it even made a voting spot because of the competition from 2K8 HierarchyID and a bunch of other spots on hierarchies not to mention the other great sessions folks had up there. Guess I'll have to publish the new method right here on SSC, eh?

Heh... thanks for the "link" before. It actually does look pretty good if you limit to 5 or fewer connections. Still going through the site.

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