Viewing 15 posts - 12,541 through 12,555 (of 49,557 total)
Then you need to use an instance name that does not exist on that server.
June 28, 2013 at 3:13 pm
Are you trying to upgrade the existing instance or create a new instance?
June 28, 2013 at 2:50 pm
Luis Cazares (6/28/2013)
Eugene Elutin (6/28/2013)
We don't order INSERTS, we order SELECTS.
Until we have identity and we want to populate it in a specific order...
Or want to do a clustered insert...
June 28, 2013 at 10:18 am
Table definitions, index definitions and execution plan please.
p.s. Watch those nolocks, do you know what effect that can have on your data accuracy?
June 28, 2013 at 6:56 am
With that log backup frequency, you have a data loss of up to 10 minutes, depending on the type of failure of the primary.
If the primary fails entirely and you...
June 28, 2013 at 4:02 am
chung_boon (6/28/2013)
June 28, 2013 at 2:46 am
Scalar functions are often bad for performance everywhere, view or otherwise.
As for compiled... Like procedures it gets compiled and optimised any time it runs and there's no plan in cache...
June 27, 2013 at 11:37 pm
girijesh.ipec (6/27/2013)
Shink Log Files and if it occurs frequently then automate Shrink file on Daily/weekly/Monthly depending on growth of log file size.
No, no, no! That is terrible advice.
If the...
June 27, 2013 at 11:46 am
2TB is the maximum possible size for a transaction log file, so unrestricted and limited to 2TB are exactly the same. It's not a side effect of file streams.
Restricted...
June 27, 2013 at 11:44 am
Indexes in most cases should be primarily there to support the WHERE clause, if they can support the WHERE and the ORDER BY, that's a bonus.
June 27, 2013 at 8:48 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
June 27, 2013 at 8:37 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
June 27, 2013 at 4:55 am
What is growing, the log file or the data file?
June 27, 2013 at 4:52 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please, direct replies to http://www.sqlservercentral.com/Forums/Topic1468076-338-1.aspx
June 27, 2013 at 4:52 am
Viewing 15 posts - 12,541 through 12,555 (of 49,557 total)