Viewing 15 posts - 211 through 225 (of 405 total)
Following link give you example of using foreach loop for ado
http://www.codeproject.com/Articles/14341/Using-the-Foreach-ADO-Enumerator-in-SSIS
Create an execute sql task that returns full resultset
You should first create a variable to hold the output...
February 18, 2013 at 9:14 pm
If they are small tables, you can ignore them. If they are bigger ones see how frequent these tables are updated. You can also try changeing the fill factor to...
February 18, 2013 at 2:11 am
For eg if your column name is CreateUser, the below query will give you all the tables wiothout the column
Select S.name,T.name
from sys.tables T join Sys.schemas S
on T.schema_id=S.schema_id
where T.object_id not...
February 18, 2013 at 2:06 am
There is not a single statement like that, but it is possible to generate athe alter statement by querying sys.columns and sys.tables.
Make sure you verify the table and schema name...
February 17, 2013 at 9:45 pm
If you need multiple rows you chnage result set to full and use an object type variable to hold the ado resultset .
December 3, 2012 at 8:12 pm
No out of the box solution is there.
But you can query system catalogue for modified date, to see schema updates.
You can run a server side trace filtered by the...
November 22, 2012 at 9:15 pm
Just to add to Gails' points,
in simple recovery model the inactive log is cleared on check point. So VLFs are affted by the file growth setting/ the your transaction durations/...
October 23, 2012 at 5:39 am
You need o run this query in th eserver you take the backups. ie the original server.
Make sure you give the correct database name. look at the databasename available in...
October 17, 2012 at 3:02 am
sean 1516 (10/17/2012)
I have a 10GB .bak file that when I restore requires 41GB. The restore fails because I currently have...
October 17, 2012 at 2:30 am
simon4132-806507 (10/16/2012)
I totally agree - I am now at the last resort phase!
We simply cannot have a database which slows down after 3-10 days.
I have looked at the statistics, but...
October 17, 2012 at 2:22 am
Freeing procedure cache in production systems should be considered only as last resort.
Did you look at the statistics. ?
October 16, 2012 at 2:37 am
You can query msdb to see the backups available for a database.
I had written a script long back for the same
http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/67296/
The data is not synch because you have not applied...
October 16, 2012 at 2:26 am
You should test it for your particular requirement and decide. Vary with your table and index structure and the resources available.
October 12, 2012 at 6:01 am
Did you check wether the mapping is correct for your login?
October 12, 2012 at 5:53 am
Viewing 15 posts - 211 through 225 (of 405 total)