Viewing 15 posts - 58,801 through 58,815 (of 59,039 total)
All good suggestions and I like the simplicity of Fred Wadley's solution. However, sometimes you can't use Bulk Insert because the DBA won't give you either "SA" permissions or "BULK...
March 7, 2005 at 6:20 am
Niel,
There is no such simple T-SQL to remove the IDENTITY property as you would remove a constraint. Even Enterprise Manager has to do a little song and dance to do...
March 7, 2005 at 5:01 am
Morean,
SellerTools' answer can easily be modified to handle 8000 characters just by changing "Declare @sql as varchar(200)" to "Declare @sql as varchar(8000)". Still, it's dynamic SQL and might be better...
March 7, 2005 at 4:04 am
Actually, it can be done without the overhead of Dynamic SQL by using a CASE statement in the WHERE clause....
FROM Table1
WHERE Name = 'AA'
AND ID...
March 5, 2005 at 9:44 am
A fellow on this forum who goes by the name of "Adam Mechanic" would have you create a permanent date table so that you can easily solve these types of...
March 3, 2005 at 6:27 am
After reading the links that Frank posted and reading "Estimating Table Size" in BOL AND reading "Data Types" in BOL, I've kind of decided that it's just easier to remember...
March 3, 2005 at 6:00 am
Guess I didn't know that... how do you forward reference a temp table?
March 2, 2005 at 7:52 pm
This could be converted to a UDF to replace GETDATE() with a date for the month to find the last business day of...
The time included in the date takes you...
March 2, 2005 at 1:57 am
Nice job and you got right to the point. Great comparison example against derived tables. My hat's off to you.
March 2, 2005 at 1:16 am
Concur... a world of hurt lays ahead for those using Unique Identifiers in a casual manner.
... and, I agree, the customer code is the unique number to be used as...
February 28, 2005 at 9:27 pm
Like I said, you have to give the hint "FIRE_TRIGGERS" to get triggers to fire during a bulk-copy or bulk-insert. If you do that, then the inserts get "logged" in...
February 28, 2005 at 9:02 pm
>"1000 Points whose values are coming after about every second"
Does this mean that the table grows by a thousand rows every second? If so, some well designed indexes would help. ...
February 28, 2005 at 5:54 am
Not unless you specify the FIRE_TRIGGERS hint which also causes the operation to become fully logged.
February 27, 2005 at 2:02 pm
Viewing 15 posts - 58,801 through 58,815 (of 59,039 total)