Viewing 15 posts - 39,301 through 39,315 (of 49,571 total)
steve smith (5/5/2009)
Nice pix - is that YOUR car, Gail?
No. That's not my blog I linked to.
May 5, 2009 at 3:24 pm
This is what snow in Johannesburg looks like
http://dotnet.org.za/codingsanity/archive/2007/06/27/snow-in-johannesburg.aspx
May 5, 2009 at 1:54 pm
It snowed here two years ago, for the first time in almost 26 years.
There was this light sprinkling of white powder over grass, plants and other surfaces which melted as...
May 5, 2009 at 1:48 pm
tdunbar (5/5/2009)
My post is indicative of how desperate I am to learn what others provide their management.
Maybe you should ask your manager what information he needs to see. It...
May 5, 2009 at 1:18 pm
Jeremy Brown (5/5/2009)
May 5, 2009 at 1:09 pm
Any errors related to model in the SQL error log?
Is your login sysadmin?
May 5, 2009 at 1:04 pm
Create a transactional replication publication with one table in it (totally irrelevance what table)
Drop the publication
Right click Replication (in management studio's object explorer)
Select Disable Publishing and distribution (providing no other...
May 5, 2009 at 1:02 pm
Searches are faster on indexed columns because SQL can quickly find the matching records rather than having to read through the entire table.
Imagine the telephone directory. Because it's in order...
May 5, 2009 at 11:07 am
Why would I ever trace a gorgeous African summer for that damp, slightly warm couple months that they call summer in the UK?
(before anyone gets offended, I'm originally from the...
May 5, 2009 at 10:31 am
There's some stuff here that may help, but it assumes you know the basics.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
May 5, 2009 at 10:26 am
I very much liked James Luetkehoelter's Pro SQL Server Disaster Recovery.
May 5, 2009 at 10:25 am
Looks like I'm the boring one.
B.Sc in Physics and Computer Science.
I wanted to go into physics, but I struggled a bit with the maths for it in 3rd year and...
May 5, 2009 at 10:15 am
Probably because the tables are small. Small tables tend not to defrag, and there's very little point anyway. Fragmentation's only a real issue on large tables when queries are doing...
May 5, 2009 at 9:42 am
Steve Jones - Editor (5/5/2009)
GilaMonster (5/5/2009)
Better idea, come down here in early Dec. You get a vacation...on a plane. Isn't it like 42 hours to fly down there?
I'm not that...
May 5, 2009 at 9:39 am
How full is the transaction log? If there's 90GB of log data in there, it won't shrink below that.
Use DBCC SQLPERF(LogSpace) to see what percentage of the log is full....
May 5, 2009 at 9:31 am
Viewing 15 posts - 39,301 through 39,315 (of 49,571 total)