Viewing 15 posts - 1,561 through 1,575 (of 7,168 total)
Cost estimate compared to the Cost threshold for parallelism setting. The QO is a cost-based optimizer.
March 18, 2013 at 4:34 pm
Sometimes the SQL statement is not captured, or it may be a UI bug. Can you save the file and attach the file to this thread? It's possible the data...
March 18, 2013 at 4:07 pm
Lynn Pettis (3/18/2013)
opc.three (3/18/2013)
ChrisM@Work (3/18/2013)
opc.three (3/15/2013)
PS Forgot to mention the function is undocumented so take that into consideration.It's a cough scalar function too.
Meh. We're talking about SQL Agent data so...
March 18, 2013 at 3:58 pm
sqldba_newbie (3/18/2013)
March 18, 2013 at 3:42 pm
brettstahlman (3/18/2013)
opc.three (3/16/2013)
March 18, 2013 at 2:56 pm
Sqlism (3/18/2013)
Thanks for the reply!Can you please explain this in more details, i use Execution utility for running this packages. so how can i differentiate 2012 and 2008R2 SSIS.
The path....
March 18, 2013 at 2:47 pm
Not that I am aware of, in general. Maybe something in your particular environment? Define "access"? Windows? Database?
March 18, 2013 at 2:43 pm
Adding the -u switch will give you a Windows Unicode (i.e. UCS-2) file. To get to UTF-8 you'll have to enlist the help of some other tool. Why do you...
March 18, 2013 at 2:41 pm
ChrisM@Work (3/18/2013)
opc.three (3/15/2013)
PS Forgot to mention the function is undocumented so take that into consideration.It's a cough scalar function too.
Meh. We're talking about SQL Agent data so IMHO it's not...
March 18, 2013 at 2:38 pm
Calling bcp might be a better option for you than using a Data Flow since bcp does not need to be armed with the table structure if using the bcp...
March 18, 2013 at 1:02 pm
32 or 64 bit SQL Server?
Server 2003 will do this to SQL 2005 quite a bit on some systems, and on others it's not an issue. It depends on what...
March 18, 2013 at 12:54 pm
Given the comment about space, I think you mean to restore the database so the data and log files are stored on a remote file share. If I guessed right...
March 18, 2013 at 10:09 am
You're welcome. Thanks for the feedback.
March 18, 2013 at 9:37 am
Those components of @@VERSION speak to the OS, not SQL Server. Here is what I use to check what you're trying to check which ensures I only see the SQL...
March 18, 2013 at 6:56 am
Eugene Elutin (3/18/2013)
If you enable READ COMMITTED SNAPSHOT in the database, it becomes the default isolation level.
For clarity READ_COMMITTED_SNAPSHOT is just a mode of the READ_COMMITTED isolation level with versioning,...
March 18, 2013 at 5:47 am
Viewing 15 posts - 1,561 through 1,575 (of 7,168 total)