Viewing 15 posts - 2,551 through 2,565 (of 19,560 total)
In most cases it is the company that decides on the title they want to call their personnel.
DBAs should be architecting solutions on a constant basis imho.
I have also found...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 7:10 pm
Can you post the error messages?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 7:04 pm
Regular depends on your transaction volume.
Shrinkfile only works if the log file is empty. If you are not backing up the transaction log, then the file will not be...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 2:01 pm
Shrinkfile won't help unless you are getting regular tlog backups.
Verify with them that they are performing those tlog backups.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 1:30 pm
Good to hear.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 1:22 pm
Can you provide more detailed information with sample DML?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 12:13 pm
A better option is to drop the second log file on the source database before you backup the database.
A second log file is pretty pointless except in the case where...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 12:11 pm
Jack Corbett (7/23/2014)
SQLRNNR (7/23/2014)
Despite the oldness of this thread, you only have those options in 2008R2.Just another driving force for the upgrade to 2012. 😉
Are you stalking me?...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 12:10 pm
Despite the oldness of this thread, you only have those options in 2008R2.
Just another driving force for the upgrade to 2012. 😉
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 11:29 am
That link I posted goes through the settings to change to make that happen. The default behavior is a snapshot of the entire publication.
Changes to those settings snaps only...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 11:10 am
You can add a new article and get it sync'd without a full snapshot.
Here is an article on how to do it.
http://ansqldba.blogspot.com/2012/02/adding-new-article-to-existing.html
The key settings are
allow_anonymous
immediate_sync
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 11:00 am
Like Jack I would consider the merge statement. One caveat is to be careful around filtered indexes.
Here is more info on that bug http://sqlblog.com/blogs/paul_white/archive/2012/12/09/merge-bug-with-filtered-indexes.aspx.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 10:57 am
TomThomson (7/23/2014)
Good question (but a pity about the unwanted editing).
+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 10:42 am
Given the Oracle options, I would prefer this Oracle as well.:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 10:40 am
It occasionally works to change the output on your source. The safest means to ensure it is the proper type though is to use a derived column transform like...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2014 at 10:39 am
Viewing 15 posts - 2,551 through 2,565 (of 19,560 total)