Forum Replies Created
Viewing 15 posts - 1,651 through 1,665 (of 6,676 total)
-
Reply To: PIVOT table with more than one aggregate and for only weeks with data.
Phil Parkin wrote:- <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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: SSIS - How to convert DateTime from ISO format
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Subquery in WHERE clause not working
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: The Basics of PowerShell Day By Day
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: SSRS conditional reporting
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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: slow query
frederico_fonseca wrote: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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Unable to debug a sproc
Jay@Work wrote: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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: SQL server SSRS 2019
Yes - you can create a data source to the 2019 instance of SQL Server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: SSRS conditional reporting
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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: slow query
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: slow query
Could you post the plan here: https://www.brentozar.com/pastetheplan/
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Unable to debug a sproc
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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Why aren't the backups working?
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Unable to debug a sproc
Jay@Work wrote:Thanks I have 20+ years experience. The individual bits run fine.
I have 67 rows go into a cursor (yeah yeah I know) and it only creates 31 rows. Everytime!
The...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Reply To: Previous row where condition exists
Using EXISTS:
Select *
From #duplicatesample d
Where Exists (Select *
...Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 15 posts - 1,651 through 1,665 (of 6,676 total)