Viewing 15 posts - 946 through 960 (of 1,228 total)
Have a look at this:
http://msdn.microsoft.com/en-us/library/ms187569(v=sql.105).aspx
Have you had a chance to configure distributed ad hoc queries to see if this helps?
July 22, 2014 at 2:38 pm
I did find something interesting on Books Online regarding CHECKDB : Just wanted to note here >
"databases that are created on SQL Server 2005 and later should never contain...
July 22, 2014 at 2:34 pm
Its possible, dont know if it will happen as we dont have DDL definitions and data here, for the two queries two produce the same execution plan on SQL Server....
July 22, 2014 at 2:07 pm
Are your reports calling stored procedures or using embedded SQL? Are there lots of joins in the code? Is all the data on the same machine?
If the sole purpose of...
July 22, 2014 at 1:42 pm
I've run dbcc checkdb(MyData) but that said 0 errors found 0 errors repaired.
Did you disconnect all users/connections from the database first?
http://msdn.microsoft.com/en-us/library/ms345598(v=sql.105).aspx
I imagine there are sections that dbcc...
July 22, 2014 at 1:06 pm
Out of curiosity why are you using subreports?
It could be he had these already existing and wanted to re use them.
Did you ever find a solution to this problem that...
July 22, 2014 at 12:34 pm
Because the data types in Excel do not fit snugly with those of SSIS. Also you have a General type (text) and can represent a number as well as a...
July 18, 2014 at 4:38 pm
The below might help:
Books online mentions the proc as "Returns aggregate performance statistics for cached stored procedures" Caching in RAM is a free for all thus anything in there would...
July 16, 2014 at 6:46 pm
I have seen older systems store all data as characters. In your initial ETL to the SQL Server I would encourage proper conversions (make date fields DATE or DATETIME2(n) ,...
July 16, 2014 at 6:29 pm
when i use the query in source as sql statement i can preview the list
Do you mean you can see the data in the preview of the data flow's source...
July 16, 2014 at 6:09 pm
Wont that just email the data from textboxes on the report - rather than a fuller underlying dataset?
Not sure what you mean here. Wouldn't you use a table or...
July 15, 2014 at 8:43 pm
Can you try doing this with Internet Explorer? Does this make a difference?
July 15, 2014 at 8:35 pm
I am curious what happens to the report once the user enters the information and the calculated column renders? Does this just come back into your database system somehow? It...
July 15, 2014 at 8:32 pm
Not sure if you missed it but the sort expression is applied to the table (not the individual columns in case you were thinking that). You set here the column(s)...
July 15, 2014 at 8:25 pm
I have to agree it is helpful to post the DDL create statements for the tables and include sample data in a consumable format
the number depends on certain word
This is...
July 15, 2014 at 8:17 pm
Viewing 15 posts - 946 through 960 (of 1,228 total)