Viewing 15 posts - 2,881 through 2,895 (of 3,232 total)
From BOL: "
Note Do not change the packet size unless you are certain that it will improve performance. For most applications, the default packet size is best."
I do not think that...
May 11, 2006 at 2:10 pm
Leave your GUID column as the unique primary key, but create it non-clustered. Then, create a descending clustered index on your int column.
May 9, 2006 at 4:06 pm
It doesn't appear that your cursor does much more than loop through your table and give you the last ID number. I did not take a very long look at...
May 8, 2006 at 2:03 pm
Have you tried rewriting the select with a join?
select col11,col12,col13=' ',col14
into dbo.table1
from remoteserver.database.dbo.table2
INNER JOIN table1
ON table2.col15 >= table1.col21
WHERE table1.col22 = 101
May 5, 2006 at 3:04 pm
How long does it take to run the SELECT col21 FROM table1 WHERE col22 = 101 statement? Is col22 indexed?
May 5, 2006 at 2:51 pm
You can split the data out using filegroups. I think you have to drop and recreate the tables you want to move. EM allows you to do this, but I...
May 5, 2006 at 2:06 pm
Schedule a second interview and make it a 'team' interview. Let your team interview him/her and just sit back and watch how the prospect interacts with the group. Make the...
May 4, 2006 at 9:23 am
You can combine your select statements into one result set using UNION. Look it up in BOL. You may also consider using a group by to get your totals. For...
May 3, 2006 at 9:59 pm
I agree, great use of numbers table. I have seen this concept explained before, but never put to use and because of that, I have not tried to use it...
May 3, 2006 at 9:37 pm
'How do you know that person is right for the job?'
Simple, you set your expectations in your job requirements. If you want to hire a DBA or developer, you must...
May 3, 2006 at 12:52 pm
Pam is on the right track. You will have to loop through the string, but it doesn't have to be 'hairy'
CREATE FUNCTION ExtractNumbers ( @String varchar(4000))
RETURNS varchar(4000)
AS
BEGIN
DECLARE @ReturnString varchar(4000),
@SubString char(1),
@index...
May 3, 2006 at 11:47 am
This function accepts a character string and, based off of the delimiter that you pass in, it will split the string down into its individual parts. Those parts are then...
May 3, 2006 at 10:33 am
Both the log shipping and BCP solutions will require some setup and testing. Read through BOL and see which method fits your needs. If you have specific questions as to...
May 3, 2006 at 9:16 am
Just curious, what will you be using this table for? It seems like you are introducing an awful lot of overhead here. How many users does this system have? ...
April 28, 2006 at 4:21 pm
If you were to issue an UPDATE lv_order SET ord_statusID = 1 WHERE ord_id = (some valid ID), your trigger will correctly update the ord_ExpShipDate column for only the one...
April 28, 2006 at 3:48 pm
Viewing 15 posts - 2,881 through 2,895 (of 3,232 total)