Viewing 15 posts - 271 through 285 (of 1,109 total)
Bill Riggio (4/8/2008)
thanks - i've already broken up the deletes. will simple mode speed up the deletes?they are being done using the primary clustered index.
Switching to simple will avoid...
April 8, 2008 at 7:47 am
Bill Riggio (4/8/2008)
approx. 15% is to be deleted from a VLDB. unfortunately it would be way too much datato copy into a temp table.
What you can do is to...
April 8, 2008 at 7:36 am
karthikeyan (4/8/2008)
yes you are correct,we can seperate it in the DTS itself.But i want to do this with sql query.
Well, in this case you will need to parse the...
April 8, 2008 at 7:33 am
karthikeyan (4/8/2008)
I already did what you have mentioned.
TableName: Imp_Text
Remarks
50,Karthik,1982,+91-044-994012345,5000.00
60,Vijay,1974,+91-044-998012345,8000.00
70,Arun,1992,+91-044-992012345,6500.00
Now i want to split it in the below format.
50 Karthik 1982 +91-044-994012345 5000.00
60 Vijay 1974...
April 8, 2008 at 5:17 am
You can create a table in which you want to load the data into, e.g.:
CREATE TABLE mytable
(
id INT,
...
April 8, 2008 at 4:40 am
Imke Cronje (4/7/2008)
Hi Guys,Is there any way in SQL to change all the user table names to lowercase.
Regards
Imke
Is your database case sensitive? If so, then you will need to update...
April 7, 2008 at 8:45 am
Phil Auer (4/7/2008)
(2). I read that when index optimization is selected in a Maintenance Plan that the DBCC REINDEX statement is run and that it creates many more entries in...
April 7, 2008 at 7:08 am
1: without the size parameter the DBCC SHRINKFILE will use the size specified when the file was created, or the last size set by using ALTER DATABASE (copy from...
April 7, 2008 at 7:04 am
Ambuj Mathur (4/7/2008)
So, this means that trans log is only affected when there is any trans backup...
April 7, 2008 at 6:34 am
The transaction log backup is not affected by a full or a differential backup. It will still contain the log entries from the last log backup.
Regards,
Andras
April 7, 2008 at 6:12 am
The cost of updating a column to the same value is not as bad as it sounds. You could check the old and new value yourself, but so does SQL...
April 7, 2008 at 2:59 am
nithyapoy (4/7/2008)
i have Table Name Country with field Country_id and Country_Name.
Country_IDCountry_Name
4 US
2 ...
April 7, 2008 at 2:19 am
Ratheesh.K.Nair (4/7/2008)
Is it possible to create a cursor inside a UDF..If possible can anyone...
April 7, 2008 at 2:12 am
When it comes to SQL Server I use sequel (just to join the herd). When it comes either to the standard or another database management system, then S-Q-L. I think...
April 4, 2008 at 9:15 am
Ravi Kumar (4/4/2008)
How to identify the backup files, whether the backup files were taken using SQL 2000 or SQL 2005 without restoring it on the database?Advance thanks,
Ravi
Use "restore headeronly". This...
April 4, 2008 at 8:45 am
Viewing 15 posts - 271 through 285 (of 1,109 total)