Viewing 15 posts - 41,581 through 41,595 (of 49,571 total)
I'm guessing that the table in question is very small?
That's normal for a small table. Anything under about 1000 pages, you don't need to worry about fragmentation
January 20, 2009 at 4:53 am
Jeff Moden (1/19/2009)
GilaMonster (1/19/2009)
🙂 and I'm in the middle of writing a blog rant titled "Bad Advice". It's funny when lots of people write on similar topics at once.
Maybe not...
January 20, 2009 at 1:28 am
Jack Corbett (1/19/2009)
My classic typo that gets past the spell checker is when I mess up "does not". Can anyone guess what my typo is?
I keep mixing 'or' and...
January 20, 2009 at 1:21 am
Jeff Moden (1/19/2009)
Jack Corbett (1/19/2009)
Here's a good blog post about people just implementing solutions form the internet or forums without caring why:http://www.straightpathsql.com/blog/2009/1/18/empirical-evidence.html
I found this on a tweet by Jonathan Kehayias.
How...
January 19, 2009 at 3:37 pm
That'll happen any time an insert doesn't succeed (due to a constraint violation, a datatype conversion error or a trigger rollback) or when rows are deleted. The id will be...
January 19, 2009 at 10:02 am
shakir (1/19/2009)
Please give me detail solutions.....
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 19, 2009 at 9:39 am
Jason Manthei (1/19/2009)
Hello,I have 1 database on my server that the recovery model is automatically changing from full to simple making my transaction log backup routines fail.
SQL will not automatically...
January 19, 2009 at 9:38 am
krypto69 (1/19/2009)
Like this Gail?
Exactly.
Would you mind editing your earlier post to do the same? It's nothing to do with the data or values, it's just to prevent the large...
January 19, 2009 at 9:22 am
Sure. Have you looked in the articles section of this website?
You can read through this - Managing Transaction Logs[/url] and this http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
And if you're still unsure, ask.
January 19, 2009 at 8:27 am
In addition, if this is ASP.Net coding, you'll probably get a much better response on an ASP.Net site (maybe the microsoft forums - http://social.msdn.microsoft.com/Forums/).
January 19, 2009 at 7:51 am
Jack Corbett (1/19/2009)
That's probably my favorite feature of the google toolbar, spell checking just like in Word.
Firefox has that built in. Why do you think I make so few spelling...
January 19, 2009 at 7:28 am
andy.brown (1/19/2009)
January 19, 2009 at 7:23 am
Please post in the appropriate forum in the future and not just anywhere you feel like.
Why do you want to shrink? Databases tend to grow as more data gets put...
January 19, 2009 at 5:17 am
Please post table definitions, index definitions and execution plan (saved as a .sqlplan file, zipped and attached)
January 19, 2009 at 5:15 am
Please post in the appropriate forum in the future and not just anywhere you feel like.
That's no a deadlock. A deadlock is when two or more processes have two or...
January 19, 2009 at 5:14 am
Viewing 15 posts - 41,581 through 41,595 (of 49,571 total)