Viewing 15 posts - 76 through 90 (of 217 total)
Well, everyone swears that no updates are done. I do not believe any updates are done. I also do not believe that any other processes occur which might...
January 5, 2012 at 12:01 pm
There is also no job shrinking the database. (I do know enough to avoid that. :-))
January 5, 2012 at 11:53 am
Auto-shrink is not on. The clustered index has 443 pages. The other indexes are about 70 pages each.
January 5, 2012 at 11:49 am
The table has about 10,000 records. It is extensively used in reporting queries by a very active data warehouse.
We were seeing performance problems on reports referencing this table yesterday....
January 5, 2012 at 11:27 am
Starting from scratch ... that ... might be, ah ... difficult to sell to management.
The really, really bad queries I can rewrite (eventually). Refactoring is more practical than starting...
January 4, 2012 at 7:16 pm
I think having a SQL team is an excellent idea.
An even better idea, in my humble opinion, is to integrate SQL developers into your existing development team and then cross-train....
January 2, 2012 at 8:19 pm
Absolutely irrelevant, of course, but I just had to say that I absolutely love your handle, Jonathan Livingston Seagull (SQL)! 😎
January 2, 2012 at 8:14 pm
If you feel that you are a mid-level developer, then I think one of the best ways to improve your skills is to dive into database design and architecture. ...
January 1, 2012 at 9:35 am
This is actually a fairly common problem. The default ANSI set options are different for .NET than they are for SSMS. the same query, submitted with different ANSI...
December 31, 2011 at 3:36 am
True, and that is an accomplishment I envy!
Really, though, you could do us all a favor by sitting down and explaining transaction locking in language the rest of...
December 30, 2011 at 6:57 am
Dude, you should write an article (or maybe a series of articles).
December 30, 2011 at 6:42 am
I agree with you. I would like to understand transaction locking in much better detail than I do currently, but in the past whenever I have investigated a locking...
December 30, 2011 at 6:29 am
Using the old (and eventually to be deprecated) ANSI-92 join syntax does not help. You should get used to the new syntax.
Old Syntax :crying:
FROM Table1, Table2
WHERE Table1.ExampleID = Table2.ExampleID
New...
December 29, 2011 at 2:12 pm
GilaMonster (12/29/2011)
This is not a technical problem and should not be approached as one, and approaching it as a battle is going to make matters worse, not...
December 29, 2011 at 12:10 pm
Well, I'd also have to simulate a production load on the QA and DEV systems. I'd have to get the head of IT do ... well, several things. ...
December 29, 2011 at 12:08 pm
Viewing 15 posts - 76 through 90 (of 217 total)