Would you expect this then ?

Posted by GrumpyOldDBA on SQL Blogcasts See other posts from SQL Blogcasts or by GrumpyOldDBA
Published on Tue, 13 Apr 2010 13:13:00 GMT Indexed on 2010/04/13 14:23 UTC
Read the original article Hit count: 407

Filed under:

Things I hate

|

File Under Grumpy

I've just been working through a database looking for log tables which can have data aged out, or deleted if you like. I was using SSMS for this and used the default right click select top 1000 rows as a quick view of the data. Establishing that I had unwanted data in such a table I deleted based upon getdate()-30 , nearly 7,000 rows deleted, I then highlighted the top 1000 rows query and re-ran query, surpisingly I still got the same result set with 2006 dates in it, and 1,000 rows. A quick...(read more)

© SQL Blogcasts or respective owner

Related posts about Things I hate

10 things the Internet has ruined and five things it hasn't

as seen on Internet.com - Search for 'Internet.com'
<b>Infoworld:</b> "From sex to Nigeria to arguments in bars to Chuck Norris: The Internet has badly affected them all (except Chuck Norris)" >>> More
How to Get Along With a Colleague You Hate

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
1. Resist sending back scathing looks or words. There is no good to be gained by lowering yourself to their position. 2. Never, ever respond negatively in writing. 3. Should or should we not approch HR with these type of problems? 4. This is my favorite tip - Kill 'em with kindness To read… >>> More
Would you expect this then ?

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
I've just been working through a database looking for log tables which can have data aged out, or deleted if you like. I was using SSMS for this and used the default right click select top 1000 rows as a quick view of the data. Establishing that I had unwanted data in such a table I deleted based… >>> More
Career advice: I am best at what I hate most

as seen on Stack Overflow - Search for 'Stack Overflow'
I think my career has entered a vicious circle which I would like to exit: I am best at what I hate most. And because I am good at that, I always receive that kind of assignments, and I do them as expected or even better. Which makes me more of an expert and brings me more similar tasks. My "expertise"… >>> More
Why do Programmers Love/Hate Objective-C?

as seen on Stack Overflow - Search for 'Stack Overflow'
So I have noticed that there is a lot of animosity towards Objective-C among programmers. What's your take? Is it a vendor lock-in thing against Apple? General antipathy towards Apple? The syntax? What's your view on this? With the advent of the iPhone SDK, Obj-C has gotten a lot more attention lately… >>> More

Related posts about File Under Grumpy

NTFS Corruption: Files created in Linux corrupted when Windows Boots

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I'm getting some file loss and corruption on my Win7/Ubuntu 12.04 dual boot setup. I have a large shared NTFS partition. I have my Windows Docs/Music/etc. directories on that file and have the comparable directors in Linux setup as a sym. link. I'm using ntfs-3g on the linux side of things to… >>> More
Prevent malicious vulnerability scan increasing load on a server

as seen on Server Fault - Search for 'Server Fault'
Hi all, this week we have been suffering some malicious vulnerability scans to our servers, increasing the load on them, making them nearly unusable. The attack is easy to defend, just blocking the offending ip, but only after discovering it. Is there any form of prevent it? Is it normal that… >>> More
yum update failed

as seen on Server Fault - Search for 'Server Fault'
I have problem doint yum update on my OpenVZ VPS i get this error message : (56/69): glibc-devel-2.5-81.el5_8.7.x86_64.rpm | 2.4 MB 00:00 (57/69): libstdc++-devel-4.1.2-52.el5_8.1.x86_64.rpm | 2.8 MB 00:00 (58/69): binutils-2.17.50.0.6-20.el5_8.3.x86_64.rpm | 2.9 MB … >>> More
Microsoft Management Console stops working when I add snap-in to it

as seen on Super User - Search for 'Super User'
I have Windows 7 Ultimate OS. I'm opening mmc.exe as administrator and trying add Certificates or any other snap-in, then while loading that snap-in MMC breaks and displays following message and after that it closes automatically once I click on close button on that message. What could be the problem… >>> More
Opening a file opens the folder the file is in, not the file itself

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Whenever I try to open a file (such as an .odt, or .doc) from say, the Dash or the Firefox Downloads, Ubuntu 11.10 opens Nautilus to the the folder where the file is, rather than just going to the application and loading the file straight away. In previous releases, when I clicked on a downloaded… >>> More