Viewing 15 posts - 7,216 through 7,230 (of 19,564 total)
sqlfriends (1/9/2012)
The problem is from the source flat files, sometimes they have data integrity issue, we cannot always to rely on them to prevent constraints violations.
Have you taken these concerns...
January 9, 2012 at 2:15 pm
GSquared (1/9/2012)
Watch out, ASCIIbetical sorting can get tricky! Even without ASCII null-character codes in the string.
Then let's go EBC
January 9, 2012 at 2:04 pm
Jack Corbett (1/9/2012)
!Aaron Aardvark! (1/9/2012)
There is a points target I'm keeping an eye on:
Guess I'm going to have up my game to stay ahead of you. Enough others have...
January 9, 2012 at 2:01 pm
!Aaron Aardvark! (1/9/2012)
Very funny, Jason.
😀
January 9, 2012 at 1:59 pm
tfifield (1/9/2012)
Take a gander as ASPDotNet Store Front if you want a horror story for table layouts. All pretty much NVARCHAR(MAX) or NTEXT.Todd Fifield
MS Dynamics/CRM 4 is pretty much...
January 9, 2012 at 1:48 pm
Steve Jones - SSC Editor (1/9/2012)
I'm starting to give away bunches to the library now.
We have several boxes (think 4u server boxes) full of books that won't fit on the...
January 9, 2012 at 1:25 pm
GilaMonster (1/9/2012)
Jack Corbett (1/9/2012)
I was going to comment that it would probably be cheaper and more productive to buy an e-reader than to keep going with bookshelves and "real" books.
Got...
January 9, 2012 at 1:21 pm
This should fix it
DECLARE AllDatabases CURSOR FOR
SELECT [name] FROM master.dbo.sysdatabases WHERE dbid > 4
OPEN AllDatabases
DECLARE @DBNameVar NVARCHAR(128),@Statement NVARCHAR(max)
FETCH NEXT FROM AllDatabases INTO @DBNameVar
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT N'CHECKING DATABASE ' +...
January 9, 2012 at 12:10 pm
I'm thinking they may have resized the database without the autogrow.
How large is the database currently? Is it 4.95Gb or was that the starting size of the DB?
January 9, 2012 at 12:00 pm
GilaMonster (1/9/2012)
Steve Jones - SSC Editor (1/9/2012)
jcrawf02 (1/9/2012)
GilaMonster (1/9/2012)
Ninja's_RGR'us (1/9/2012)
There was a time I loved fiction, got any books to recommend?
Yes
http://sqlinthewild.co.za/index.php/2012/01/01/2011-book-review/
http://sqlskills.com/BLOGS/PAUL/post/2011-the-year-in-books.aspx
We both have 2010 posts as well if you feel...
January 9, 2012 at 11:52 am
Permissions don't always cascade to child folders. Check the subfolders and confirm permissions exist there.
Even though it works in your stage environment, it is not a guarantee that it...
January 9, 2012 at 11:50 am
In addition to blogspot, there is wordpress.com.
If you are looking to use it as a part of your brand, you might consider getting a domain and hosting the blog there.
Another...
January 9, 2012 at 11:08 am
Aaron Aardvark (1/9/2012)
SQLRNNR (1/9/2012)
SQL Kiwi (1/9/2012)
GSquared (1/9/2012)
Yes, but not at the posts count thing. Just at the "change your name to something even sillier than GSquared" thing.
You don't think...
January 9, 2012 at 10:58 am
SQL Kiwi (1/9/2012)
GSquared (1/9/2012)
Yes, but not at the posts count thing. Just at the "change your name to something even sillier than GSquared" thing.
You don't think 'Aaron Aardvark' has...
January 9, 2012 at 10:48 am
Viewing 15 posts - 7,216 through 7,230 (of 19,564 total)