February 1, 2016 at 10:30 am
Ed Wagner (2/1/2016)
jasona.work (2/1/2016)
Just read through the topic in question, sounded a bit to me as being more like "Please indicate that this may be OK as I really don't want to call MS Licensing and sit on hold for half the day," instead of "give me the answer I want."Well, the bottom line is that we're not Microsoft. They have the answer that matters.
Absolutely...
My answer for any sort of licensing question is "I'm not a Microsoft Licensing Specialist, call them."
On that note, I probably would have given bad advice, which is why I stay away from licensing questions...
February 1, 2016 at 10:54 am
jasona.work (2/1/2016)
Ed Wagner (2/1/2016)
jasona.work (2/1/2016)
Just read through the topic in question, sounded a bit to me as being more like "Please indicate that this may be OK as I really don't want to call MS Licensing and sit on hold for half the day," instead of "give me the answer I want."Well, the bottom line is that we're not Microsoft. They have the answer that matters.
Absolutely...
My answer for any sort of licensing question is "I'm not a Microsoft Licensing Specialist, call them."
On that note, I probably would have given bad advice, which is why I stay away from licensing questions...
I try to apply some logic to it in that if it is used for production in any way (no matter how small), then it's probably production and will have to be licensed as production. I don't want to spend extra money, but Microsoft wants everyone to spend all the money.
February 1, 2016 at 11:26 am
Ed Wagner (2/1/2016)
jasona.work (2/1/2016)
Ed Wagner (2/1/2016)
jasona.work (2/1/2016)
Just read through the topic in question, sounded a bit to me as being more like "Please indicate that this may be OK as I really don't want to call MS Licensing and sit on hold for half the day," instead of "give me the answer I want."Well, the bottom line is that we're not Microsoft. They have the answer that matters.
Absolutely...
My answer for any sort of licensing question is "I'm not a Microsoft Licensing Specialist, call them."
On that note, I probably would have given bad advice, which is why I stay away from licensing questions...
I try to apply some logic to it in that if it is used for production in any way (no matter how small), then it's probably production and will have to be licensed as production. I don't want to spend extra money, but Microsoft wants everyone to spend all the money.
Having just gone through almost the same exercise, the examples provided all sounded like production to me.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 1, 2016 at 1:22 pm
GilaMonster (1/30/2016)
Ed Wagner (1/29/2016)
Is it really that much better than SSMS intellsense? I'm asking because I don't know; not trying to start a riot.Oh, hell, yes. SSMS intellisense wastes more time than it saves due to its habits of autocorrecting strange things. SQLPrompt can be configured to activate when you want, not automatically, has some actual intelligence and saves me huge amounts of time.
That's before we get to the auto-format script, auto-insert ;, auto-qualify columns, find invalid objects in the entire database, find unused parameters/variables in the current script, etc
+1 for each point raised by Gail
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
February 1, 2016 at 1:25 pm
WayneS (1/31/2016)
How many Threadizens are going to SQL Saturday Cleveland this upcoming weekend? I'll be flying in Thursday night; I'd love to meet up with you (even better... come on out to my session!)
Cleveland doesn't rock this year so not going.
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
February 2, 2016 at 5:11 am
WayneS (1/31/2016)
How many Threadizens are going to SQL Saturday Cleveland this upcoming weekend? I'll be flying in Thursday night; I'd love to meet up with you (even better... come on out to my session!)
Thinking about it. As I cannot take Friday off I cannot go to that session. Would really like to hear Jeff.
February 2, 2016 at 7:22 am
To the experts of DBCC TIMEWARP
Why can't system databases be restored "with move" like the others?
Example: RESTORE database model with move -> The system database cannot be moved by RESTORE
February 2, 2016 at 12:53 pm
<rant>
I'm not sure what's worse. An article promoting RBAR code or comments arguing that the code in the article won't work even if it does.
Some people's fingers work faster than their brains.
</rant>
I'm sorry, I just can't stand when people just complain with no valid arguments (even when they should complain).
February 2, 2016 at 1:01 pm
Luis Cazares (2/2/2016)
<rant>I'm not sure what's worse. An article promoting RBAR code or comments arguing that the code in the article won't work even if it does.
Some people's fingers work faster than their brains.
</rant>
I'm sorry, I just can't stand when people just complain with no valid arguments (even when they should complain).
What article? Firing up the popcorn machine now. 😛
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 2, 2016 at 1:04 pm
Sean Lange (2/2/2016)
Luis Cazares (2/2/2016)
<rant>I'm not sure what's worse. An article promoting RBAR code or comments arguing that the code in the article won't work even if it does.
Some people's fingers work faster than their brains.
</rant>
I'm sorry, I just can't stand when people just complain with no valid arguments (even when they should complain).
What article? Firing up the popcorn machine now. 😛
Yesterday's headline: http://www.sqlservercentral.com/articles/data+integrity/136279/
February 2, 2016 at 1:25 pm
Luis Cazares (2/2/2016)
Sean Lange (2/2/2016)
Luis Cazares (2/2/2016)
<rant>I'm not sure what's worse. An article promoting RBAR code or comments arguing that the code in the article won't work even if it does.
Some people's fingers work faster than their brains.
</rant>
I'm sorry, I just can't stand when people just complain with no valid arguments (even when they should complain).
What article? Firing up the popcorn machine now. 😛
Yesterday's headline: http://www.sqlservercentral.com/articles/data+integrity/136279/
I couldn't resist. THANK YOU for posting the ROW_NUMBER solution. BTW, the fn_PhysLocFormatter function is in the resource database.
February 2, 2016 at 1:29 pm
Luis Cazares (2/2/2016)
Sean Lange (2/2/2016)
Luis Cazares (2/2/2016)
<rant>I'm not sure what's worse. An article promoting RBAR code or comments arguing that the code in the article won't work even if it does.
Some people's fingers work faster than their brains.
</rant>
I'm sorry, I just can't stand when people just complain with no valid arguments (even when they should complain).
What article? Firing up the popcorn machine now. 😛
Yesterday's headline: http://www.sqlservercentral.com/articles/data+integrity/136279/
WOW. I didn't read any of the articles yesterday. Some of the comments in there are truly shocking.
My day yesterday was such a Monday. It all started with 87,000+ error emails in my inbox. One of services went haywire and sent an error email 6 times a minute since Thursday. One of our former developers was supposed to put some logic in that service to only attempt to process a given file a maximum of three times. I see now that never happened as it kept trying to import the same file every 10 seconds for four days. It was a simple fix. Every now and then the mainframe will randomly add a carriage return in the middle of one of these flat files and the import process can't parse it.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 2, 2016 at 9:11 pm
SQLRNNR (2/1/2016)
WayneS (1/31/2016)
How many Threadizens are going to SQL Saturday Cleveland this upcoming weekend? I'll be flying in Thursday night; I'd love to meet up with you (even better... come on out to my session!)Cleveland doesn't rock this year so not going.
...aaaaand, off to dig up Drew Carey Show and watch it again....
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 2, 2016 at 9:32 pm
So I'm in this college course called "Database Development", 400 level course. Instructor has so far told the class that Oracle is "inconsistent" because it fails to find a table when searching a view for object name = the string literal 'Employees' differently than directly named objects in the FROM clause (SELECT * FROM EMPLOYEES / SELECT * FROM employees). Object is named EMPLOYEES officially, but she didn't understand that the handling of strings was consistent, since the system can't predict what will be in the string.
Yesterday she said that we "didn't need indexes on smaller databases". When I suggested that perhaps if she was referring to indexes purely for performance improvement I could see the point (although that assumes we don't really *want* our application to succeed and have to scale), but surely we needed primary keys still, she replied "you are right, you don't need primary keys in smaller databases" (wut??? I didn't say that!)
Now it's not a db design class, but still, we should at least be attempting to teach students rather than handicap them, right? They'll screw up enough on their own...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 3, 2016 at 1:57 am
Wow, that's just terrible Jonathan.
I think you have two courses of action here.
First, go to the school's principal, file an official complaint, and request a refund.
Second, do not do the above immediately but go to one more class and tell all the students to do this.
The latter is of course much more awkward and can put you in a tight spot, but you will protect the other students from this terrrible influence and perhaps even get her licence revoked.
Viewing 15 posts - 52,501 through 52,515 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply