@CadeRoux In Budapest street musicians are harassed by the authorities. In theory you can get a permit, but it is ridiculously difficult. So no chance here for such a performance...
Hi Mark, I promised a reference for my claim that pre-industrialisation lifespans were comparable to modern man—but a little reading has led me to believe I was exaggerating at best :) This article seems pretty well balanced: johnhawks.net/weblog/reviews/life_history/…
He links to a very sciency pdf that concludes: "We are not living as long as we thought we were."
@dezso Inside Irvin's house. The kids were still napping after a long morning at the zoo so we couldn't go across the street. But here's a photo from twitter.
Now that's what I call a study break! Sunday house concert at @IrvinMayfieldJr's with @rebirthBB. http://t.co/mUtP1Qvz
a server had a bad stick of RAM for 3 years. They're going to replace it but they're making up reasons for taking the server down so that folks don't realize there was a bad stick for 3 years
@Zane It's undocumented for a reason ;-) but seriously, aside from documentation, how often do you need to do the exact same operation for each and every table?
@jcolebrand What this sproc is doing is sketchy at best. Its a sproc that calls two different sprocs. One of them runs sp_MSforEageTable to turn of constraints to change some config data which why it's doing that in a supposedly relational model completely baffles me. Once it's done it's insert it runs MSforEageTable again to turn them back on.
Unfortunately the database that runs on is completely out of my hands hopefully a strong recomendation will be good enough to get the developers to fix that problem.
@JackDouglas its a box i'm kind of loosely connected with. Technically I could assume control of it if I wanted to - but it would be dangerous with office politics and generally I have no need to.
i just dl, installed, and ran the new sp_Blitz script
i got result for a "High VLF Count" and the details give me "The [ReportServer] database has 0 virtual log files (VLFs). This may be slowing down startup, restores, and even inserts/updates/deletes."
Several ways.
You can set the EDITOR environment variable before running SQL*Plus (Assuming Unix), to allow use of an external text editor (vi, by way of example):
export EDITOR=vi
Then type ed in SQL*Plus to edit the previous query in the vi editor. Of course, you may prefer nano, pico, emac...
@Mat should add his comment as an answer and EPQRS should accept this answer. otherwise this query will be found in the list pf queries without an answer. — miracle1733 hours ago
Anyone here ever sell a domain name? How do you know if an appraisal is accurate? I had a bunch of sites say $150, another site say $1500 and I have an offer of $1000. I don't even know if I want to sell it.
@swasheck tweetcars.com is listed for sale for $2600, so I'm thinking those other sites just default names to $150 - thinking tweetcar.com has to be worth more than $150.
The buyer's name is Jafar. Should I be worried he's an evil wizard?
@ypercube ... maybe @BenBrocka can come in and tell us all about online marketing. we had a conversation about this in the past and i agree with your sentiment.
So technically if they have 36 on Home Improvement and 11 on Database Administrators you can still super-ping them here (but chat uses an aggregate rep I think)
@user1578653 in short, thanks for posting your question and coming back with a self-answer, but please don't post comments like "Someone downvote this guy please" on someone's post. Do it here in The Heap ;)
This includes no more fuss over the associated answers, commentary (existing, if new harassing commentary arises, please inform us via the appropriate mechanisms) or etc.
@swasheck something like that ... we start with feathers, but I pack a mean swing.
so apparently my boss ran into our old DBA (who is now consulting) - told the previous guy that he should let us know the places he's consulting at so that I can follow after and clean up! lol
Does anyone know if SQL Server 2008 stores the creation date for execution plans? I was hoping to see if some schema changes might have forced some new plans being made, which would slow down a user's experience.
I'm a new admin for an MS access database. I'm very new to MS Access so please forgive me if I ask something that does not make sense here....
The current staff has a small (5MB or so) .mdb file on their desktop. Clicking that file opens access and lists queries on the left hand side of Access...
If I'm not mistaken once the plan is changed or removed from the cache it is just cleared out.
For example if you run SELECT * FROM sys.dm_exec_cached_plans you will see not dates there. once the plan is gone it's gone. Unless someone brighter than I knows otherwise
We recently upgraded an application we use, which involved modifying the schema for the database. These changes could have forced cached execution plans to be discarded. If SQL Server was forced to create a bunch of new plans, this could have slowed down the user experience. I'd like to find out ...
It isn't stored in sys.dm_exec_cached_plans, nor is it buried anywhere in the plan XML that I can find. There is useful information in other DMVs however.
For stored procedures we can get the time a plan was cached from sys.dm_exec_procedure_stats:
SELECT TOP(250)
p.name AS [SP Name]
,...
@swasheck I've not questioned why its deemed good behaviour to nolock everything from the DMVs but its widespread practice. Glenn Berry's DMV scripts use it everywhere.
@MarkStorey-Smith yeah. i'm just saying to wait for them to start commenting, perhaps not knowing what they're saying, just that someone once said that (NOLOCK) is bad practice
AFAIK the change from creation_time to cached_time was just because procedures and triggers were added in 2008 and the opportunity was taken to choose a more descriptive name. The created/cached time reflects the last compilation, not the creation time of the original plan.
@MikeFal Not deprecated. People move to isolation level from table hints because it is easier to change when they want to move to e.g. RCSI, and ultimately less typing and less error-prone (easy to miss off a NOLOCK hint).
@MarkStorey-Smith Just edit, no credit necessary. And for the love of fluffy bunnies don't put EDIT or UPDATE text in the answer :)
@SQLKiwi Gotcha. I see where I was thinking of the deprecation, looks like it was deprecated on UPDATE and DELETE statements for the FROM clause. msdn.microsoft.com/en-us/library/ms143729.aspx
I'm a new admin for an MS access database. I'm very new to MS Access so please forgive me if I ask something that does not make sense here....
The current staff has a small (5MB or so) .mdb file on their desktop. Clicking that file opens access and lists queries on the left hand side of Access...
@EugeneM What Mike said. What's your level of expertise and interest areas? Tom has quite a list there - we might be able to pick some out for you to look at first.
@EugeneM Off the top of my head, @SqlKiwi, @AaronBetrand, all the SQLSkills.com crew, Chris Webb, Adam Machanic, @BrentOzar and crew, Thomas Kejser, Jason Strate, @JohnSansom (nice little weekly blog roundup/links), Michael Swart... that should get you started :)
@EugeneM you can also spend time on Twitter trolling through #sqlhelp and watch the experts' answers. most of the ones that @MarkStorey-Smith just listed are active on there, too
plus, if you can establish yourself as "less-than-wanker" then you can ask dumb questions and get good answers. it's how i've been able to sustain a community presence.
I'm a new admin for an MS access database. I'm very new to MS Access so please forgive me if I ask something that does not make sense here....
The current staff has a small (5MB or so) .mdb file on their desktop. Clicking that file opens access and lists queries on the left hand side of Access...
Several ways.
You can set the EDITOR environment variable before running SQL*Plus (Assuming Unix), to allow use of an external text editor (vi, by way of example):
export EDITOR=vi
Then type ed in SQL*Plus to edit the previous query in the vi editor. Of course, you may prefer nano, pico, emac...
I'm a new admin for an MS access database. I'm very new to MS Access so please forgive me if I ask something that does not make sense here....
The current staff has a small (5MB or so) .mdb file on their desktop. Clicking that file opens access and lists queries on the left hand side of Access...
It isn't stored in sys.dm_exec_cached_plans, nor is it buried anywhere in the plan XML that I can find. There is useful information in other DMVs however.
For stored procedures we can get the time a plan was cached from sys.dm_exec_procedure_stats:
SELECT TOP(250)
p.name AS [SP Name]
,...
