Viewing 15 posts - 16 through 30 (of 42 total)
As Jeff implies, fuzzy logic is something you build yourself in your queries (or sometimes within the application tools that actually make use of those queries) rather than it being...
March 9, 2015 at 4:58 am
I've found it's general advisable to avoid index hints almost always.
Indexes change, data changes, you might be forcing something to run in a way that used to be appropriate when...
March 6, 2015 at 10:30 am
I really like Backup > Copy > Restore.
It's probably my most used method as it is simple, reliable, easy to set up, fully controllable, and has the added advantage of...
March 6, 2015 at 10:20 am
If I've remembered it correctly, there's no direct way to do this in 2005 Editions.
My first suggestion is to leave a lightweight server-side Profiler Trace running, designed to just catch...
March 6, 2015 at 6:49 am
Excellent news; enjoy the rest of your week.
March 5, 2015 at 6:55 am
From just watching the first few seconds I THINK that this is similar to the method in the link I posted.
From the look of the YT comments it seems to...
March 5, 2015 at 5:20 am
OK, you're in a bit of a pickle here, as the server has been left in a state where there is only one login that has Sys Admin rights and...
March 5, 2015 at 5:01 am
If I'm reading your question correctly, it might simply be a case of changing the language that the login connects under, for instance from English to British English - that...
March 5, 2015 at 4:21 am
Obviously you must be some kind of administrator user yourself to change the password.
The only effect it will have is that, if anything uses the sa login to log into...
March 5, 2015 at 4:14 am
Just to add another voice to confirm - you cannot do this - going "forward" is sadly impossible.
What your friend was probably thinking of is that you can take an...
March 5, 2015 at 4:12 am
OK; let us know how you get on.
March 4, 2015 at 10:45 am
Sure thing; you can install just the client tools wherever you like with no problem at all.
Just make sure that you, or whoever helps with the installation, selects only the...
March 4, 2015 at 8:41 am
Perhaps a silly direction for me to take, but can you confirm the following:-
1. The SQL instance is up and running on the box (simply check in services is probably...
March 4, 2015 at 3:37 am
suvorav (3/4/2015)
I am using XEvent session instead profilerbut I cannot realize how to configure the session to find out what SP case this error
Hmmm, not a method with which...
March 4, 2015 at 1:45 am
Ah, good old "string or binary data" - the annoying thing is that SQL must know which field and input clash caused the error, but it doesn't seem to want...
March 3, 2015 at 7:55 am
Viewing 15 posts - 16 through 30 (of 42 total)