Viewing 15 posts - 571 through 585 (of 1,065 total)
Is it better to first drop the indexes, then truncate the table and recreate the indexes at the end of the inserts?
Absolutely... performance of the inserts should be much...
July 15, 2009 at 2:55 am
so you might as well ship something that's 80% right and then plan on fixing it right away
I have to disagree with that notion.
If I buy some software, I want...
July 15, 2009 at 2:51 am
Peso (7/14/2009)
Also a GUID is not "globally" unique. It is guaranteed to be unique within same sql server only.
Are you sure?
This is from BOL
The uniqueidentifier data type stores 16-byte binary...
July 15, 2009 at 1:42 am
Russell.Taylor (7/7/2009)
Thanks for the reply but I am using SQL Server 2000 so does not work.
Doh!!
Sorry, ROW_NUMBER isn't supported in SQL 2000.
There is a solution using a self join (join...
July 7, 2009 at 10:05 am
Try this:-
-- 1 - Declare variables
DECLARE @CMD1 varchar(8000)
DECLARE @RestoreRootDirectory varchar(255)
DECLARE @CurrentDate datetime
DECLARE @CurrentName varchar(8)
-- 2 - Initialize variables
SET @CMD1 = ''
SET @RestoreRootDirectory = 'c:\backups\test\'
SET @CurrentDate = GETDATE()
SELECT @CurrentName =...
July 7, 2009 at 6:18 am
This will get you the top 2 for each id:-
WITH cte AS (SELECT id, quantity, ROW_NUMBER() OVER(partition by Id ORDER BY Id, quantity desc) AS 'RowNumber' from mytable)
select id,quantity from...
July 7, 2009 at 4:49 am
Rather than add a SortOrder column to the table, just include one in your query e.g.
select id, forename, case when forename = 'Kim' then 1 else 2 end as SortOrder
from...
July 7, 2009 at 1:04 am
ali.m.habib (7/6/2009)
so what if I want to run it on my D drive on my pc
You will need to refer to it using UNC notation (\\mypc\d\\alianz\output\CEMTXOUT_ALIANZ)... which means sharing your...
July 6, 2009 at 7:41 am
Is this file definately accessible by the server hosting your SQL instance.
Don't forget, "'D:\alianz\output\CEMTXOUT_ALIANZ'" is referring to the D: drive on the server, not the workstation you are connecting from.
Also,...
July 6, 2009 at 7:09 am
Having all these links in a central place is a good idea, but they are more likley to be seen by the veterans than the newbies.
The newbies seem to have...
July 6, 2009 at 6:47 am
That third party tool will not interfere with the SQL Server native backup chain. And the backup chain will not interfere with the third party tool's chain.
I beg to differ....
July 6, 2009 at 5:55 am
Do I need to include the GO statement after declaring the variable
GO isn't actually a TSQL statement... it is used by the likes of SSMS etc to signify the end...
July 3, 2009 at 8:12 am
It's 32767.
If you need anything like this, look up Maximum Capacity Specifications in BOL.
July 3, 2009 at 7:23 am
What exactly do you mean?
If you want to remove a merge replication publication, you can right-click the publication in Enterprise Manager and click "Delete"
July 3, 2009 at 7:12 am
I'm shocked and appalled some people have a total disregard for Referential Integrity.
Can't say I'm shocked... Appalled, yes.;-)
July 3, 2009 at 7:01 am
Viewing 15 posts - 571 through 585 (of 1,065 total)