Viewing 15 posts - 46 through 60 (of 517 total)
If you're dealing with a typical 1-instance 2-node cluster:
Patch/reboot the passive node, wait for it to come back up.
Fail over the instance to the passive node, wait for it to...
February 17, 2011 at 3:33 pm
But then what's the point, because I can just as easily declare a table variable, populate it with an insert query, and loop through it with a while loop. ...
February 17, 2011 at 2:04 pm
dmc-608719 (2/17/2011)
February 17, 2011 at 9:50 am
GSquared (2/17/2011)
February 17, 2011 at 8:48 am
Exporting to XML shouldn't be an issue since it doesn't care about data types...unless for some reason you have them specified in the flat file properties. I tend to just...
February 17, 2011 at 8:44 am
TheSQLGuru (2/17/2011) Come to think of it, I have had to clean up quite a few DTA SNAFUs.
Let's not forget theoretical indexes that DTA creates during testing that it fails...
February 17, 2011 at 8:40 am
Yep, SQL rarely uninstalls cleanly.
Google around for manual uninstall directions, which basically just involves removing the entire MS SQL Server branches from the registry. Reboot and try the install again.
I've...
January 31, 2011 at 3:46 pm
It depends..
Contains() is great for fuzzy lookups, searching for strings near other specific strings, thesaurus, etc...it does a lot of things. Since it is designed to do all that, there's...
January 25, 2011 at 2:57 pm
You say 'Like' is slower, but that's not what your original post says..did you reverse those?
January 25, 2011 at 2:45 pm
If you want the database to stay at exactly 4gb, then just set its initial size to that and disable autogrowth. There is no need to shrink it after that...
January 25, 2011 at 2:44 pm
Contains() is a much more powerful command and for your purposes I think it's overkill for a string lookup.
Note the missing index warning at the top of the query...
January 25, 2011 at 2:22 pm
isuckatsql (1/25/2011)
I ran an execution plan, but dont really have any experience in this area, so i opened a ticket with Microsoft.Thanks again!
If you post the execution plans here, we...
January 25, 2011 at 1:12 pm
Good - now it looks like the connection is fine and now it's a code issue.
That's not really my forte, but here are a few links that look promising and...
January 25, 2011 at 1:09 pm
I noticed my model log sizes growing too..this was because I had automated jobs running that cycled through every database checking fragmentation, size, backups, etc...any 3rd party monitoring tools would...
January 25, 2011 at 12:52 pm
Do you have named pipes enabled in the sql server network config?
Are you positive it's running on port 1433?
January 25, 2011 at 12:48 pm
Viewing 15 posts - 46 through 60 (of 517 total)