Viewing 15 posts - 1 through 15 (of 26 total)
ok, now i have start to work on it. let checks out, what will happen. i will tell you the result.
great thanks .....;-)
December 16, 2010 at 11:07 pm
Thanks for reply.
ok i will put extra tables into different file group, but when i will delete extra data then it not automatically shrink the database. i have to manually...
December 15, 2010 at 9:05 pm
Yes, I prefer to have data in a Filegroup for Data, and leave the PRIMARY Filegroup for the system tables. It won't hurt you to do this.
Yes 20 tables each...
December 15, 2010 at 2:21 am
"I have studied in sql book , data should be .ndf files."
Should i create the different file group to load the data or should i use only primary.
I also...
December 15, 2010 at 12:10 am
GilaMonster (9/22/2010)
pankaj.kuchaliya (9/22/2010)
i have to insert near about 5-7k row from different database to current database by using SP. which have been called in Trigger on the basis of date.
Now...
September 22, 2010 at 11:48 pm
Lowell (9/22/2010)
exec [sp_ETL_To_Rpt] @frmdt,@todt
since your trigger says it's also for DELETE, and...
September 22, 2010 at 11:39 pm
Jack Corbett (9/20/2010)
September 20, 2010 at 9:29 pm
Bhuvnesh (9/20/2010)
pankaj.kuchaliya (9/20/2010)
I fire the query "select * from sys.dm_db_missing_index_details " , i see there are lots of indexes.
You should not blinding trust this information. this is not helpful...
September 20, 2010 at 4:17 am
pankaj.kuchaliya (9/15/2010)
Dave Ballantyne (9/15/2010)
DTA will not help you if your queries are poor in the first place, such as the one stated in one of your other threads.http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx
suppose i have...
September 15, 2010 at 3:16 am
Dave Ballantyne (9/15/2010)
DTA will not help you if your queries are poor in the first place, such as the one stated in one of your other threads.http://www.sqlservercentral.com/Forums/Topic986028-360-1.aspx
suppose i have 5-6...
September 15, 2010 at 3:04 am
Gianluca Sartori (9/15/2010)
It depends. You're not describing your problem with enough detail to get a sensible answer.Can you give us a more detailed description of your requirement?
I have web service...
September 15, 2010 at 2:59 am
pankaj.kuchaliya (9/15/2010)
Dave Ballantyne (9/15/2010)
Though its good you have posted the plans, what statement is causing the Timeout ?
when i call the stored procedure from front end then i display the...
September 15, 2010 at 2:53 am
GilaMonster (9/15/2010)
The functions on the columns will force at least an index scan, possibly even a table scan.What do those UDFs do?
here is the function details................
ALTER Function [dbo].[Fn_HHMM](@DT DATETIME)
Returns VARCHAR(5)
As
Begin
Declare...
September 15, 2010 at 2:51 am
Dave Ballantyne (9/15/2010)
Though its good you have posted the plans, what statement is causing the Timeout ?
when i call the stored procedure from front end then i display the time...
September 15, 2010 at 1:27 am
GilaMonster (9/9/2010)
pankaj.kuchaliya (9/9/2010)
How can i create file group on different physical drive.
The same way you create a file any other time. Just as a location put the other drive's drive...
September 9, 2010 at 5:46 am
Viewing 15 posts - 1 through 15 (of 26 total)