Viewing 15 posts - 346 through 360 (of 498 total)
You could also set up one database as the "Master" and then use Snapshot replication to replicate the procedures and functions. Another way is to create a DTS Package that...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 15, 2003 at 11:26 am
I first noticed that happen in SQL 7. I have been using the SQL-92 syntax JOIN syntax ever since. Once you get used to writing your queries this way you...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 15, 2003 at 11:20 am
Good point Greg. I totally missed the 6.5 compatibility. I'm so used to working with a SQL 2K database I never even looked at that.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr....
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 15, 2003 at 11:15 am
My guess is that your table has null values as Madhu indicated and you either need to update the null values to a specific value or drop off the NOT...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 14, 2003 at 3:37 pm
I think if you break this down as a select statement you will see why it does this. try running the following:
Select fname
...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 14, 2003 at 3:23 pm
Well let's see. If all you are doing is selecting data in your XML files and the files are fairly small then XML might be faster. As soon as you...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 10, 2003 at 6:33 pm
I agree with Nick, this is too general of a topic to cover here. But here is the way I would tackle this.
1: Map your database fields to the...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 10, 2003 at 6:18 pm
You might try the following... Since I don't have a schema to try it on it may fail. But it should give you the idea.
SELECT
...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 10, 2003 at 5:54 pm
I do this all the time. As kleb_writes said you want to check for errors after ANYTHING that might cause an error. As a note you also want to check...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 10, 2003 at 5:27 pm
I've used the stage table technique for a long time to weed out dupes. It is by far the easiest way to go. Plus you can archive the stage table...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 10, 2003 at 5:18 pm
In addition to the above you will want to script out the users/logins and move them manually first. Then once the database has been restored I would double check to...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 10, 2003 at 5:13 pm
You might be able to get around this if you use TOP 100 PERCENT on your subquery that you want to order by.
use...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 10, 2003 at 5:08 pm
quote:
I like to put the drop in myself. Sometimes to debug a procedure, I copy it into QA and comment out...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 10, 2003 at 4:57 pm
I usually basically do what Crispin does in his example. I feel this is much easier to read and I already have the function to split the string 🙂
Gary Johnson
Microsoft...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 8, 2003 at 3:50 pm
I always put a drop statement right before the creation with a check to see if the table exists. Most users won't run into the problem of having the table...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 8, 2003 at 3:39 pm
Viewing 15 posts - 346 through 360 (of 498 total)