Viewing 15 posts - 4,486 through 4,500 (of 9,715 total)
That's because they're using the same schedule (you can have jobs use an existing schedule, or each job have their own brand new schedule). Delete the schedule from job 3...
April 13, 2012 at 5:25 am
Larry Page(Ehs_Akb) (4/12/2012)
this is the source code of that
You misunderstand what he said. If you want to put the code in a web page and post the URL of the...
April 13, 2012 at 5:13 am
Larry Page(Ehs_Akb) (4/12/2012)
you mean i have to generate the data?
Um, that's what I've been telling you. If you want to data mine, you need data (not information). There's a difference.
can...
April 13, 2012 at 5:09 am
Forgot about the variable option. I retract the "the only way" part of my earlier post.
April 13, 2012 at 5:05 am
What you do then is to create two report variables, one for EXP and one for IMP. Then have the variables subtract from each other.
FYI: It's been a while since...
April 13, 2012 at 5:02 am
SQL won't let you do that. The only way to guarantee order is to have two different UPDATE statements, or to fix your current one to pass in the hard...
April 13, 2012 at 5:00 am
How is full text searching a limitation if you are allowed to use it?
April 13, 2012 at 4:57 am
So I'm using Display Estimated Execution Plan for the first time in SQL 2008 and fun, fun, it displays "missing indexes" across the top.
Then I find an index suggestion where...
April 13, 2012 at 4:47 am
Per Books Online (Top clause):
Specifies that only the first set of rows will be returned from the query result. The set of rows can be either a number or a...
April 13, 2012 at 4:40 am
Sounds like a homework question to me. Have you Googled your questions yet? Or read SQL Server Books Online?
April 13, 2012 at 4:37 am
Look up Common Table Expressions and Google spforeachTable (First link is here: http://www.databasejournal.com/features/mssql/article.php/3441031/SQL-Server-Undocumented-Stored-Procedures-spMSforeachtable-and-spMSforeachdb.htm). See if that helps.
April 13, 2012 at 4:35 am
I don't use data collection, but if these are two separate jobs, shouldn't you be able to schedule them so they run one after the other instead of at the...
April 13, 2012 at 4:33 am
You have to pull the EXP and the IMP fields into the expression for Imbalance.
=SUM(Fields!IMP.Value) - SUM(Fields!EXP.Value)
I probably have the field names wrong, but it's really not that hard. Make...
April 13, 2012 at 4:32 am
This is the newbies guide to installing the patch:
Go to Microsoft's download pages, download the patch to a good drive location that does not contain your SQL files or your...
April 12, 2012 at 6:07 pm
Steve Jones - SSC Editor (4/12/2012)
April 12, 2012 at 1:53 pm
Viewing 15 posts - 4,486 through 4,500 (of 9,715 total)