Viewing 15 posts - 646 through 660 (of 961 total)
christhurajsacraj (7/25/2011)
When there is more No.of transaction means the log file get filled.
We need to clear the log file and...
July 25, 2011 at 3:38 am
what do you have set under the option "delete files older than the following'. have you tried running the plan manually or are you waiting for a job to execute...
July 25, 2011 at 3:34 am
Whats the exact error message you get when you trying to connect to the local instance.
How many services and what names do you have for sqlserver services under the services...
July 25, 2011 at 2:54 am
Do you want to add 51 weeks to the date ?
Year has 52 therefore 51 is a whole year minus the last week.
select dateadd(wk,51,GETDATE())
July 25, 2011 at 2:37 am
Since you asked the question I assume your not a regular DBA and just wants a solution which would get the job done. If your the performing the activity I...
July 25, 2011 at 2:23 am
Lookup MSDN
http://msdn.microsoft.com/en-us/library/bb522469.aspx
OFFLINE
Sets the file offline and makes all objects in the filegroup inaccessible.
Caution note Caution
Use this option...
July 25, 2011 at 2:18 am
It seems this database was recently restored with no recovery. Looks like your facing 2 different problems now , the first to do with backup plans and the second with...
July 25, 2011 at 2:12 am
Is sal1 means salary then the tables you have just created are fact tables.
A dimension is a set of data on which you want the axis to be sliced on
The...
July 22, 2011 at 6:24 am
Jayanth_Kurup (7/22/2011)
maybe you cud try something...
July 22, 2011 at 5:30 am
whats the purpose of doing this audit ? Are you trying to identify frequently called procedures or do you suspect a proc causing a deadlock etc ?
July 22, 2011 at 4:58 am
overall without the table def and execution plan the only thing i can think of is the where clause where your using the like operator
maybe you cud try something like...
July 22, 2011 at 4:52 am
if your looking for a long term audti then DDL trigger is a good appraoch , if this is a one time activity then you can run a trace on...
July 22, 2011 at 4:43 am
I think the source of this could be in the underlying File system. NTFS seems to have better IO performance when using 8 KB cluster sizes , but I am...
July 20, 2011 at 2:04 am
The actual limit is 2 GB. the 4 GB is split into parts with a 2GB shared kernel and the remaining 2 GB dedicated to the application.
By enabling the PAE...
July 19, 2011 at 12:44 am
Viewing 15 posts - 646 through 660 (of 961 total)