Viewing 15 posts - 1,651 through 1,665 (of 6,679 total)
@JeffModen - although your code works in SQL Server, it will not work in an expression in an SSRS report.
Although you can figure out how to use the same type...
August 20, 2020 at 9:28 pm
I am not sure what your problem is based on the pictures...a page footer will take up as much space as you define for it in the design window and...
August 16, 2020 at 3:31 pm
<li style="list-style-type: none;">
- That's an unusual looking statement in the ORDER BY (CONVERT(VARCHAR, ompcreateddate + 84, 101)). Does it achieve something which ORDER BY ompcreateddate does not?
It isn't...
August 14, 2020 at 4:48 pm
Since you do not include an offset - you can convert directly to DATETIME2. For these types of columns - I would just define them as a string in SSIS...
August 14, 2020 at 4:38 pm
It looks like you have 2 columns in each row from the Plan table that you want to check against. Or maybe it is just one row in the Plan...
August 13, 2020 at 9:27 pm
There are many editors available for Powershell - and the default Windows Powershell ISE works quite well for basic scripting. It allows writing the script and executing command line and...
August 13, 2020 at 8:19 pm
Setup a data-driven subscription...you then create a query that returns the appropriate data and assign those values to each of the parameters for the email.
August 10, 2020 at 9:01 pm
Jeffrey Williams wrote:Could you post the plan here: https://www.brentozar.com/pastetheplan/
I've already uploaded it here as a zip file.
I saw that after I posted...thanks.
August 10, 2020 at 8:51 pm
Thanks but my OP was asking abut the debugging feature in VS and if anyone had run into the same errors
Since Microsoft has removed the capability to debug stored...
August 10, 2020 at 8:49 pm
Yes - you can create a data source to the 2019 instance of SQL Server.
August 10, 2020 at 8:38 pm
If you have Enterprise Edition you can use a data-driven subscription. If you are running Standard Edition - then you would create separate subscriptions for each set of email recipients.
August 10, 2020 at 8:36 pm
I see a bunch of table scans - which seems to indicate based on the estimates - a table variable or a heap (which should still have some statistics). The...
August 10, 2020 at 7:58 pm
Could you post the plan here: https://www.brentozar.com/pastetheplan/
August 10, 2020 at 7:44 pm
https://docs.microsoft.com/en-us/sql/ssms/scripting/transact-sql-debugger?view=sql-server-ver15
From this document: This feature works with SSMS version 17.9.1 and earlier.
August 10, 2020 at 7:29 pm
What is the version of TFS?
Have you looked at this documentation: https://docs.microsoft.com/en-us/azure/devops/server/upgrade/upgrade-2013/backup-and-restore-data?view=tfs-2015
It appears to me that there is a separate tool you need to run on the TFS server to...
August 9, 2020 at 4:28 pm
Viewing 15 posts - 1,651 through 1,665 (of 6,679 total)