Viewing 15 posts - 2,386 through 2,400 (of 49,552 total)
river1 (9/14/2016)
I know that I can decrease the isolation level inside stored procedures so that they don't cause locking.
Wrong question.
You should be fixing (tuning) the procedure so that it doesn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 11:43 am
Please note, 6 year old thread
(and the error's not caused by insufficient free space, but rather by a limit on the size of sparse files)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 7:29 am
The instructions look clear enough? What's the problem?
A path is only needed if you want the file written somewhere other than the directory you run the command from (by default...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 7:25 am
Can someone familiar with SQL to SQL linked servers help out please
http://www.sqlservercentral.com/Forums/Topic1817509-2799-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 7:13 am
Msg 7202, Level 11, State 2, Procedure Vw_DBSize, Line 3
Could not find server 'targetserver' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 6:52 am
No.
If you switch to bulk-logged, you'll have to take log backups, that's the only difference.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 6:49 am
The view has the correct information and you just obfuscated it for the forum?
If you run just the select statement, does it return results?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 6:33 am
Bharat21 (9/14/2016)
check below query and suggest how make query for take count of accessed this stored procedure and triggers on SQL server in last 30 days
Hugo already...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 6:32 am
If you run just the select statement, does it return results?
Do you really have a linked server named "LinkedserverName,Portnumber"??? If so, why?
And what type of database is it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 5:09 am
ChrisM@Work (9/14/2016)
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 5:06 am
Optimal, maybe. Secure, very likely not.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 3:27 am
Mike Scalise (9/14/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2016 at 3:24 am
Pages (which are 8kb in size). Most reads/writes shown by SQL, unless specified as in kb or bytes, will be in pages
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 13, 2016 at 10:33 am
Try
COUNT(*) OVER (PARTITION BY edata.dbo.e_ClientCases.Client)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 13, 2016 at 10:30 am
sys.dm_tran_database_transactions gives information about how much log space was used for a transaction.
Extended events writes should give you total writes, if the correct events are selected (sql vs sp), sys.dm_io_virtual_file_stats...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 13, 2016 at 9:39 am
Viewing 15 posts - 2,386 through 2,400 (of 49,552 total)