Viewing 15 posts - 4,231 through 4,245 (of 9,643 total)
I didn't take the time originally to examine your table structure, but if you were to re-arrange the order of the key columns in your primary key to put wh_id...
September 17, 2009 at 9:18 am
Edit: Just found duplicate post here. Please don't post duplicates. I wouldn't have wasted my time answering if I had seen an answer already.
Can you better define...
September 17, 2009 at 9:11 am
Duplicate post. Please post answers here
September 17, 2009 at 9:02 am
Have you looked at the transfer database task?
September 17, 2009 at 9:02 am
Since your columns are defined as non-unicode then when you provide unicode values to the where clause SQL Server has to do an implicit conversion which is likely forcing scans...
September 17, 2009 at 8:58 am
Michael has given you probably the only option because once you have given rights to database objects to a login then that login can access the those objects from any...
September 17, 2009 at 8:55 am
There is no way to tell you what is the best because it varies by the situation. Certainly backing up daily and having transaction log backups are good. ...
September 17, 2009 at 7:48 am
I'm sure the issue was that he set up database mail, but did not configure SQL Server Agent to use database mail. It is a common mistake to forget...
September 17, 2009 at 7:44 am
You need to look into using the matrix control which allows you to Pivot/Cross tab the data.
September 17, 2009 at 7:42 am
This looks like the code you found is for Oracle.
There is not a way that I know of to do what this trigger does because this looks like...
September 17, 2009 at 7:40 am
Instead of doing new trace and then save as a template have you you tried using File -> Templates -> New Template? I was able to create a template...
September 17, 2009 at 7:35 am
Yusuf,
There really isn't much you can do about it with the Date type. You can make it a string type, but then you lose the calendar control. Your only...
September 17, 2009 at 5:39 am
We had short debate about this in planning for SQLSaturday #21 - Orlando. One of the sponsors wanted to have some time to do a demo of one of...
September 14, 2009 at 6:50 am
Apparently I agree with Gus and Gianluca.
September 11, 2009 at 6:49 am
Viewing 15 posts - 4,231 through 4,245 (of 9,643 total)