Viewing 15 posts - 1 through 15 (of 25 total)
Or a cursor over sys.all_objects to filter tables and execute EXEC 'ALTER TABLE ' + @youTable + ' ADD...'
-
Lic. Andrés M. Aiello
DBA MSSQL - Oracle
http://aiellodba.blogspot.com/
@AndresAiello
September 22, 2011 at 7:56 am
I miss understand the problem. I think that next execution try to read, but it's the app isn it? well the best option is MERGE and you will not need...
September 15, 2011 at 10:39 am
use merge statment, it's the best option. In other hand just serialize querys in steps, soo a job don't invoque next execution until finish one.
-
Lic. Andrés M. Aiello
DBA MSSQL -...
September 15, 2011 at 7:57 am
verify SQL browser it's running and firewall rules to admit that port.
September 15, 2011 at 7:54 am
there's a problem when you set permissions to backup operator. The user can't backup from managment studio, only by commando line o query. That's because MS perform some select to...
September 12, 2011 at 11:11 am
you well come 🙂
September 1, 2011 at 9:32 am
here I wrote an article about that: http://aiellodba.blogspot.com/2011/08/entendiendo-el-waitresource.html
August 31, 2011 at 8:32 am
remember also that with TDA you will lose any compression (I love sql 2008 bk compression!!!)
August 31, 2011 at 8:30 am
with integration you can copy image. I use a IS pkg to export image avery day, and I'm talking about 1Tb of images... where did you read that you can't?
August 31, 2011 at 8:24 am
In many case I set up sql service broker to catch querys and log in a table, but it's a "hand job"
August 31, 2011 at 8:21 am
I enter this post thinking to write, but gianluca was clean enogth 🙂
August 31, 2011 at 8:20 am
depend of situation use filestream or varbinary. If you read freaquently use filestream, in other case varbinary(max)
August 31, 2011 at 8:17 am
try to capture a trace and find problem querys, for starting the ones with great IO (read principal). SQL 2008 is not more performance "per se", but have a lot...
August 31, 2011 at 8:14 am
I preffear to store in db, a lot of times you need to join data from a lot of xml and that very flexible if there are in db.
August 31, 2011 at 8:10 am
You're right, only appear encrypted text. new tip of the day!
-
Lic. Andrés M. Aiello
DBA MSSQL - Oracle
August 25, 2011 at 12:51 pm
Viewing 15 posts - 1 through 15 (of 25 total)