Forum Replies Created
Viewing 15 posts - 661 through 675 (of 2,356 total)
-
Reply To: Connection String for Access 2016 ADODB to SQL Server 2019
Is there an actual error you are receiving? There's not enough information here.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Error connecting to the Read-Only Replica from Application
Your secondary is not configured to allow a readable secondary.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Sharing an SSRS ReportServer database
If I understand your question, you want to use the same SQL installation for multiple SSRS installations? If that's true, I have a single SQL server that contains 4 different...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Best Practice question
ScottPletcher wrote:{Thousands of recompiles a day} vs {thousands of extra table scans a day} is an easy choice. I'd have to see actual damage from the recompiles to recommend differently. ...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Best Practice question
Johan Bijnens wrote:Test the given catch-all options ! YMMV ( I'm on the "option (recompile) should be a last choice" side)
Yeah. Without duplicating some tests of this that I did quite...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Best Practice question
Yes. WHERE character_column LIKE ‘string%’
To elaborate, currently when a user calls the help desk, we need to identify the client they work for, as well as a few other things....
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Best Practice question
ScottPletcher wrote:Actually you could be causing a performance problem by getting SQL to use the same query plan for different values, i.e., by avoiding the "overhead" of a recompile. The...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Are the posted questions getting worse?
Well, this is interesting. SQL 2022. No more parameter sniffing?
https://www.youtube.com/watch?v=ncF-zFzBDAY
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Query to fetch top SQL statements
Search this site for "query performance" or sys.dm_exec_query_stats.
There are a wealth of queries that will tell you what you need.
This one is a start.
select top 20
...Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Best Practice question
To expand upon this, and maybe provide some ideas that can ease your pain, here are some thoughts. I had this same situation a while back. The difference was that...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Best Practice question
Jeff Moden wrote:mike 57299 wrote:The example is for a query called by the Customer List page of the web application. It will execute 1000's of times a day.
In that case, please see...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Printing Strings Longer Than 8000 Characters
RonMexico wrote:To expand on the reason I'm not using other DDL scripting methods is because I'm looping through hundreds of tables and running tests on converting data types and changing...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Need advice with backup plan and transaction log file
One could argue that your plan is fatally flawed.
It should not be a backup plan, it should be a recovery plan.
As such, you likely would have discovered the answers to...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Printing Strings Longer Than 8000 Characters
I'm with Phil. Why are you doing this?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Reply To: Restart SSA in a job?
Can you explain further? How exactly are you refreshing this? Backup and restore? Replication Snapshot? Something else?
Once the process completes, you then run a re-index process. Why? Are the indexes...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 15 posts - 661 through 675 (of 2,356 total)