November 27, 2012 at 12:31 pm
Revenant (11/27/2012)
Jo Pattyn (11/27/2012)
DBCC Timewarp: Active Directory returns to 19 november 2000. New singer Linda Merts for the popular belgium pop/dance group. Waar zijn die handjes?:-DSorry, this airplanes me. What is it supposed to mean?
This is a Belgian inside joke.
In 2000 the somewhat popular dance group Milk Inc. got a new singer: Linda Mertens. The DJ of the group has a somewhat ridicilous habit of shouting "Waar zijn die handjes" during concerts, which is translated as "Where are those hands?"
Not sure what Milk Inc. has to do with Active Directory though 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 27, 2012 at 1:20 pm
November 27, 2012 at 2:07 pm
Koen Verbeeck (11/27/2012)
Revenant (11/27/2012)
Jo Pattyn (11/27/2012)
DBCC Timewarp: Active Directory returns to 19 november 2000. New singer Linda Merts for the popular belgium pop/dance group. Waar zijn die handjes?:-DSorry, this airplanes me. What is it supposed to mean?
This is a Belgian inside joke.
In 2000 the somewhat popular dance group Milk Inc. got a new singer: Linda Mertens. The DJ of the group has a somewhat ridicilous habit of shouting "Waar zijn die handjes" during concerts, which is translated as "Where are those hands?"
Not sure what Milk Inc. has to do with Active Directory though 😀
After I listened to this group for about ten minutes, and having some experience with Active Directory, I think I found: unless you are a big fan of Dance Electronica and confusing APIs, avoid them. 🙂
November 27, 2012 at 2:17 pm
Revenant (11/27/2012)
Koen Verbeeck (11/27/2012)
Revenant (11/27/2012)
Jo Pattyn (11/27/2012)
DBCC Timewarp: Active Directory returns to 19 november 2000. New singer Linda Merts for the popular belgium pop/dance group. Waar zijn die handjes?:-DSorry, this airplanes me. What is it supposed to mean?
This is a Belgian inside joke.
In 2000 the somewhat popular dance group Milk Inc. got a new singer: Linda Mertens. The DJ of the group has a somewhat ridicilous habit of shouting "Waar zijn die handjes" during concerts, which is translated as "Where are those hands?"
Not sure what Milk Inc. has to do with Active Directory though 😀
After I listened to this group for about ten minutes, and having some experience with Active Directory, I think I found: unless you are a big fan of Dance Electronica and confusing APIs, avoid them. 🙂
Isn't "avoid them" good advice no matter which dance group somewhat popular in 2000 "them" might refer to?
Tom
November 27, 2012 at 4:12 pm
L' Eomot Inversé (11/27/2012)
Revenant (11/27/2012)
Koen Verbeeck (11/27/2012)
Revenant (11/27/2012)
Jo Pattyn (11/27/2012)
DBCC Timewarp: Active Directory returns to 19 november 2000. New singer Linda Merts for the popular belgium pop/dance group. Waar zijn die handjes?:-DSorry, this airplanes me. What is it supposed to mean?
This is a Belgian inside joke.
In 2000 the somewhat popular dance group Milk Inc. got a new singer: Linda Mertens. The DJ of the group has a somewhat ridicilous habit of shouting "Waar zijn die handjes" during concerts, which is translated as "Where are those hands?"
Not sure what Milk Inc. has to do with Active Directory though 😀
After I listened to this group for about ten minutes, and having some experience with Active Directory, I think I found: unless you are a big fan of Dance Electronica and confusing APIs, avoid them. 🙂
Isn't "avoid them" good advice no matter which dance group somewhat popular in 2000 "them" might refer to?
I thought I might give them an opportunity to disappoint me, just like Active Directory APIs.
November 28, 2012 at 12:08 am
L' Eomot Inversé (11/27/2012)
Isn't "avoid them" good advice no matter which dance group somewhat popular in 2000 "them" might refer to?
For some obscure reason they're still popular. They still sell out the biggest venue in Belgium and a few years back they played at Rock Werchter (which has been voted best festival of the world numerous times) alongside Metallica.
I don't get it either 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 28, 2012 at 4:52 am
Jo Pattyn (11/27/2012)
DBCC Timewarp: Active Directory returns to 19 november 2000.
The interesting thing about this article is the following line:
The forest root PDC or master time servers in the forest lacked time jump protection
Then why didn't they just call in the Doctor to fix the problem?
Or maybe he WAS the problem. @=)
November 28, 2012 at 6:13 am
Grant Fritchey (11/27/2012)
jcrawf02 (11/27/2012)
Okay, so looking at the new ads from redgate on the site, and thinking Steve is obviously Hannibal, which makes Grant...Mr. T?No, no, no. I am the pretty guy or the crazy guy.
Pretty sure you're the scary guy, which means I Pity The Fool...:-P
---------------------------------------------------------
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."
November 28, 2012 at 6:16 am
jcrawf02 (11/28/2012)
Grant Fritchey (11/27/2012)
jcrawf02 (11/27/2012)
Okay, so looking at the new ads from redgate on the site, and thinking Steve is obviously Hannibal, which makes Grant...Mr. T?No, no, no. I am the pretty guy or the crazy guy.
Pretty sure you're the scary guy, which means I Pity The Fool...:-P
Quit making fun of Murdoch. @=)
November 28, 2012 at 10:34 am
Since a few of you are experienced, we're looking for a few disaster recovery stories on fairly short notice for the week of the 10th. If you want to write up a page or two on something you've dealt with or experienced, we'd love to hear it.
November 28, 2012 at 10:49 am
Anyone with more patience than me want to try and handle this?
http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx
Previous threads on the subject:
http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx
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
November 28, 2012 at 11:36 am
GilaMonster (11/28/2012)
Anyone with more patience than me want to try and handle this?http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx
Previous threads on the subject:
http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx
I'm going to do a horrible thing and ask a technical question prompted by the above. Please don't flog me off The Thread. @=)
Gail said
If pages are read in from disk for a table and there's not space in the buffer pool, other pages will be removed from it, maybe even pages of the same table that have already been read by the query processor.
Data read by the query processor goes somewhere. When in SSMS, it's outputting to the screen or the file, so it makes sense to me that these pages are cleaned. But has there ever been an instance where the data has nowhere to go yet (still needs other processing before results are presented) that could ... I dunno, cause SQL to error out or seize?
Or am I asking a silly question?
November 28, 2012 at 12:05 pm
Brandie Tarvin (11/28/2012)
Data read by the query processor goes somewhere. When in SSMS, it's outputting to the screen or the file, so it makes sense to me that these pages are cleaned. But has there ever been an instance where the data has nowhere to go yet (still needs other processing before results are presented) that could ... I dunno, cause SQL to error out or seize?
Huh?
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
November 28, 2012 at 12:08 pm
Brandie Tarvin (11/28/2012)
GilaMonster (11/28/2012)
Anyone with more patience than me want to try and handle this?http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx
Previous threads on the subject:
http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx
I'm going to do a horrible thing and ask a technical question prompted by the above. Please don't flog me off The Thread. @=)
Gail said
If pages are read in from disk for a table and there's not space in the buffer pool, other pages will be removed from it, maybe even pages of the same table that have already been read by the query processor.Data read by the query processor goes somewhere. When in SSMS, it's outputting to the screen or the file, so it makes sense to me that these pages are cleaned. But has there ever been an instance where the data has nowhere to go yet (still needs other processing before results are presented) that could ... I dunno, cause SQL to error out or seize?
Or am I asking a silly question?
No and no.
Re the first No, I know positively that the SQLS QA guys have tests for these conditions. For example - and it is one out of many -, when a result of an outer join is really big and the server runs out of disk space, the engine is expected to drop the rowset and terminate the query gracefully with an error message, and it apparently does, or the build would not pass.
November 28, 2012 at 12:38 pm
Revenant (11/28/2012)
Brandie Tarvin (11/28/2012)
GilaMonster (11/28/2012)
Anyone with more patience than me want to try and handle this?http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx
Previous threads on the subject:
http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx
http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx
I'm going to do a horrible thing and ask a technical question prompted by the above. Please don't flog me off The Thread. @=)
Gail said
If pages are read in from disk for a table and there's not space in the buffer pool, other pages will be removed from it, maybe even pages of the same table that have already been read by the query processor.Data read by the query processor goes somewhere. When in SSMS, it's outputting to the screen or the file, so it makes sense to me that these pages are cleaned. But has there ever been an instance where the data has nowhere to go yet (still needs other processing before results are presented) that could ... I dunno, cause SQL to error out or seize?
Or am I asking a silly question?
No and no.
Re the first No, I know positively that the SQLS QA guys have tests for these conditions. For example - and it is one out of many -, when a result of an outer join is really big and the server runs out of disk space, the engine is expected to drop the rowset and terminate the query gracefully with an error message, and it apparently does, or the build would not pass.
That's about where I was going with my question, though I didn't phrase it as gracefully as you phrased the answer.
Thank you.
Viewing 15 posts - 38,326 through 38,340 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply