276 reputation
26
bio website martinstoller.ca
location Earth
age 84
visits member for 3 years, 3 months
seen Sep 18 at 14:00

What to write... what to write? Does anyone read these at all?

With over twenty years of programming experience, I think I've finally earned the title "veteran" (got the scars to prove it, too). And that, even though I've only been gaining my daily bread with full time programming during the last 16 years. Before that I was doing admin and support work, getting my hands and knees dirty pulling a plethora (and yes, I do mean "abundance") of cabling through ducts that greased spaghetti would have had trouble passing through. Beating reluctant UNIX and Novell servers with a one pound mallet until they agreed to work in rooms radiating a pleasant 38 degrees Celsius. With soothing, well modulated words calming down workers close to suicide who had unwittingly rebooted their machines before saving their gargantuan spreadsheets. During these perspiring years I often put together small tools and apps to help make my admin life easier. And in the early years of my computerized life (during high school) I programmed for fun in languages and on machines that have now been more or less forgotten. All those years I've dreamt of designing and creating the "PERFECT OPERATING SYSTEM"! But that is another story…


Jul
13
awarded  Yearling
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jan
6
comment Granting SA privileges for Developers on the development box
+1 for the question, as I've hit that issue a couple of times. Another solution: Give the devs a sandboxed VM with SQL on it that they are 100% boss of. They are also 100% responsible for keeping it alive :) -> it is amazing how fast the DEVs learn not to break their own system :)
Jan
3
comment How can I learn to become a DBA?
+1 for the link - And BOZAR is also a MCM for a while now...
Jan
3
answered What is a good way to verify that a restore completed successfully in SQL Server?
Oct
14
revised Why is query using Clustered Index when it shouldn't?
Removed un-useful link and snippet as per comment.
Oct
14
comment Why is query using Clustered Index when it shouldn't?
@Mark Storey-Smith - After reading the whole thing again, I see your point, so removed the link as it just confuses the issue...
Oct
14
revised Why is query using Clustered Index when it shouldn't?
Added snippet from SQL Solutions
Oct
14
comment Why is query using Clustered Index when it shouldn't?
@Martin Smith - Sorry D'Oh moment there on my part. Index fragmentation only really affects DISK IO (so in memory indexes would not suffer from fragmentation) as per MSDN/TechNet. I was remembering the old days where indexes could become out of date from too many changes - BUT that isn't possible with MSSQL. Quote MSDN: "The SQL Server Database Engine automatically maintains indexes whenever insert, update, or delete operations are made to the underlying data". Would be a good idea to forget deprecated facts :) Otherhand looks like EST#Rows is used as a decision point. Looking for doc proof.
Oct
14
awarded  Editor
Oct
14
revised Why is query using Clustered Index when it shouldn't?
Added snippet form linked article
Oct
13
awarded  Commentator
Oct
13
comment Why is query using Clustered Index when it shouldn't?
If you hover over the "select" item in the EP, what does it show as "Estimated # of Rows"? I've noticed (for the case as per the given example) that if the number is proportionality high to the # of total rows, SQL ends up doing only the Clustered Index Scan, as SQL decides that is the cheaper route to go.
Oct
13
comment Why is query using Clustered Index when it shouldn't?
Just tested with 2005+2008, and it does scan the nonclustered index (although with 50% to 75% cost, depending on my data set). Perhaps you need to rebuild the index - if SQL thinks it is too "dirty" and thus costly, it may decide not to use it.
Oct
13
answered Why is query using Clustered Index when it shouldn't?
Oct
13
comment Attaching a MDF with a missing LDF
Did you also try this? -> windowscoding.com/blogs/blake/archive/2007/10/06/…
Sep
1
comment Why are my SQL Server 2008R2 databases not mirroring?
Just for clarity, did you also restore the transaction backups? And 5GB is not large :) The free, "Express SQL 2008" version supports 10GB per DB, to put things into perspective...
Aug
4
comment Is it possible to install a MS SQL Express Studio, where the studio tool also is included?
Two resources: [sqlblog.com/blogs/aaron_bertrand/archive/2011/06/14/… ] and [microsoft.com/download/en/details.aspx?id=26727 ]. I don't bother looking up, but 10.50.1617 sounds like a few (security) updates have been applied to the installation (SP1 is v 10.50.2500).
Jul
24
comment How to export a single huge table from SQL Server?
+1 cause great minds think alike :)