August 1, 2011 at 8:37 am
Roy Ernest (8/1/2011)
I just downloaded from their site. This is where I downloaded it from.
Tx.
August 1, 2011 at 8:37 am
Need help over here... can't explain why stats are getting dropped with no apparent good reasons :
http://www.sqlservercentral.com/Forums/Topic1151771-391-1.aspx
August 1, 2011 at 8:56 am
GilaMonster (7/29/2011)
Koen Verbeeck (7/29/2011)
Ugh. Another copyright violation.http://www.sqlservercentral.com/Forums/Topic1150675-391-1.aspx?Update=1
Original article:
http://www.databasejournal.com/features/mssql/sql-server-index-t-sql-statements.html
Thanks, I was going to spend the afternoon tearing it apart. Lots of bad info in there.
Another one bit the dust. I missed it (except the Database journal version).
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
August 1, 2011 at 9:03 am
Ninja's_RGR'us (7/29/2011)
Do you guys(als) know a way to remove the prints from the backup / restore commands?This is what I'd like to be gone from the output :
100 percent processed.
Processed 99 pages for database 'DemoRecover', file 'DemoRecover_log' on file 1.
BACKUP LOG successfully processed 99 pages in 0.037 seconds (21.836 MB/sec).
Ummm - start by wearing latex gloves.
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
August 1, 2011 at 9:09 am
SQLRNNR (8/1/2011)
Ninja's_RGR'us (7/29/2011)
Do you guys(als) know a way to remove the prints from the backup / restore commands?This is what I'd like to be gone from the output :
100 percent processed.
Processed 99 pages for database 'DemoRecover', file 'DemoRecover_log' on file 1.
BACKUP LOG successfully processed 99 pages in 0.037 seconds (21.836 MB/sec).
Ummm - start by wearing latex gloves.
Way ahead (or behind) you!
August 1, 2011 at 9:10 am
GilaMonster (7/29/2011)
Stefan Krzywicki (7/29/2011)
That's a good water-cooler topics, what games do you play on your phone? I haven't found much that's really kept my attention for more than a month or so.The phone is purely casual games, they're for the 5 minutes waiting for a take-out, stuck in a supermarket queue, etc.
Unblock Me
Plumber
Hungry Shark
Star Traders
The iPad's for slightly longer, more complex games, the PC/laptop are for the really hard-core games
Hungry shark is fun - kids enjoy it too.
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
August 1, 2011 at 9:12 am
Stefan Krzywicki (7/29/2011)
GilaMonster (7/29/2011)
Stefan Krzywicki (7/29/2011)
On the desktop, there's much more to play, Civ V, City of Heroes, Europa Universalis III, EuroRails, etc...I am resisting Civ 5. Want, but...
At the moment, Witcher (1), Anno 1404, Fallout 3, Farcry 2, Mass Effect 2 on XBox. Have Dragon Age 1 waiting (yes, I'm behind). Heaven knows what I'm going to do end of this year. Skyrim and The Old Republic. Starcraft 2 part 2 soon...
Need a vacation just to catch up on games....
I need to try Starcraft 2 at some point.
Same boat - need to play Starcraft 2
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
August 1, 2011 at 9:16 am
GilaMonster (7/31/2011)
In other news... Anyone willing to read over an article on recovery models and make sure I haven't made any grievous errors?
Yes - I'd love to have a crack at it.
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
August 1, 2011 at 9:39 am
I played some Halo series with my son, but not much lately. We tried to get the kids into RockBand, which has a tiny game piece, but no luck.
Words with Friends with my wife and a few SQL people, and BeJeweled are about the only gaming I do.
August 1, 2011 at 11:11 am
Need help to figure out if sql agent is uselessly filling the plan cache or if it's due to 3rd party application (commvault) >>
http://www.sqlservercentral.com/Forums/Topic1151929-146-1.aspx
August 1, 2011 at 2:43 pm
Bad day today. Needed telephone for various things (could use mobile, but (a) expensive and (b) no loudspeaker and area mike so wife and I couldn't have joint conversation with third party). No dial tone on fixed line phones this morning. Unplugged everything and then checked master socket by plugging in wired BT handset - still no dial tone. ADSL still works fine when I plug filters and router back in, but still no dial tone. Report it to BT (using non-BT mobile phone) - answer is that it's a fault in their exchange, they'll try to mend it by end of Thursday. Best part of 4 days to fix a "not connected" fault??? That's cazy, appalling, mustn't say what I really feel as need vocabulary not suitable for family wesite like SQLSCentral. That's service level for fixed line phones provided by effective monopoly provider BT in UK. Last time I had similar problem in Spain, Telefonica were falling over themselves to fix it, reported problem late afternoon and fixed before noon next day, Telefonica ringing up to apologise that it had happened at al and that it had taken so long to fix, and to check that it really did work now (and it wasn't their fault in the first place - some idiot developers had dug up a few metres of underground phone line). Vast difference in attitude to customers, customer service. Must persuade wife we don't need to come back to UK each summer, as BT is typical of utility companies in UK, would be better off staying away.
Tom
August 1, 2011 at 2:48 pm
Tom.Thomson (8/1/2011)
Bad day today. Needed telephone for various things (could use mobile, but (a) expensive and (b) no loudspeaker and area mike so wife and I couldn't have joint conversation with third party). No dial tone on fixed line phones this morning. Unplugged everything and then checked master socket by plugging in wired BT handset - still no dial tone. ADSL still works fine when I plug filters and router back in, but still no dial tone. Report it to BT (using non-BT mobile phone) - answer is that it's a fault in their exchange, they'll try to mend it by end of Thursday. Best part of 4 days to fix a "not connected" fault??? That's cazy, appalling, mustn't say what I really feel as need vocabulary not suitable for family wesite like SQLSCentral. That's service level for fixed line phones provided by effective monopoly provider BT in UK. Last time I had similar problem in Spain, Telefonica were falling over themselves to fix it, reported problem late afternoon and fixed before noon next day, Telefonica ringing up to apologise that it had happened at al and that it had taken so long to fix, and to check that it really did work now (and it wasn't their fault in the first place - some idiot developers had dug up a few metres of underground phone line). Vast difference in attitude to customers, customer service. Must persuade wife we don't need to come back to UK each summer, as BT is typical of utility companies in UK, would be better off staying away.
Ah, fond memories of Ma Bell!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 1, 2011 at 3:05 pm
........(and it wasn't their fault in the first place - some idiot developers had dug up a few metres of underground phone line). .
How do you know it wasn't the DBA dug the phone line up?
---------------------------------------------------------------------
August 1, 2011 at 3:05 pm
4 days? That's excellent service.
Here a telephone fault often takes a few weeks to sort out. I had a fault several years ago where I reported the line as not working every week for 2 months. At the end of the 2 months I called and asked for the service (well, actually just the billing) to be terminated. I was still getting bills 3 months later. I asked a friend to speak personally with a senior manager and get the mess sorted out. It took another month before I got a letter notifying me that the line had been disconnected and they were refunding me 2 months service charges because of the fault and reminding me that I still owed them money.
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
August 1, 2011 at 3:10 pm
GilaMonster (8/1/2011)
4 days? That's excellent service.
Same problem with my ISP. I had two accounts and decided to cancel one of them. ISP locked both lines to my house from the service box. No internet for 4 days.
At least they are offering a discount for their screwup.
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
Viewing 15 posts - 28,591 through 28,605 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply