Arsh

Forum Replies Created

Viewing 15 posts - 106 through 120 (of 335 total)

RE: SQL Server instance slowness

coolchaitu - Friday, December 15, 2017 2:18 AM
How do i find queries ? Please share the script
You can use this for...

December 16, 2017 at 3:28 am

#1972372
RE: Resource DB backup

Absolutely right. Thank you Sue and Grant.

December 14, 2017 at 2:02 am

#1972082
RE: Scripting Tables with ALTER with dependencies

Jeff Moden - Sunday, December 10, 2017 4:19 PM
Arsh - Saturday, December 9, 2017 4:25 AM

December 13, 2017 at 7:58 am

#1971957
RE: Job getting stuck in UAT but runs fine in Prod

Is the infrastructure(Memory/Processors etc.) for UAT at the same level as for production ? If at lower level , this can also be an issue.

December 8, 2017 at 7:37 am

#1971363
RE: Trans Log backup of Log Shipped DB

Sue_H - Thursday, December 7, 2017 4:02 PM
Arsh - Thursday, December 7, 2017 9:20 AM

December 8, 2017 at 4:42 am

#1971335
RE: SQL can't start . Please kindly help

WhiteLotus - Wednesday, November 29, 2017 3:14 AM
2017-11-29 18:56:16.78 spid7s Could not continue scan with NOLOCK due to data movement.
2017-11-29 18:56:16.78 spid7s Error: 945,...

November 29, 2017 at 7:32 am

#1969915
RE: Table Design

Thank you everybody for putting in points for the design aspects. Would be great if you can also advise me on the design tools available in the market, and...

November 28, 2017 at 3:24 am

#1969652
RE: Index Key Re-Ordering

GilaMonster - Monday, November 20, 2017 5:32 AM
No. The data is ordered by the index key. Logically ordered, but still ordered.
The...

November 24, 2017 at 6:42 am

#1969391
RE: Column Length

GilaMonster - Thursday, November 23, 2017 7:28 AM
Aaron wrote the article this year, not back around the time of SQL 2008.
And,...

November 23, 2017 at 8:16 am

#1969350
RE: Column Length

DesNorton - Thursday, November 23, 2017 4:20 AM
That statement was made by Scott Pletcher.
Hi Des , Oh yeah it was Scott....

November 23, 2017 at 6:55 am

#1969343
RE: Column Length

Arsh - Friday, September 29, 2017 5:59 AM
DesNorton - Wednesday, September 27, 2017 11:41 PM

November 23, 2017 at 3:13 am

#1969334
RE: Table Design

Thank you Jeff, John, Lynn, Grant and Bill for the points. How about column lengths ? There's a debate with dev team especially on Varchar. Where 20 is enough, they...

November 22, 2017 at 7:37 pm

#1969310
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

Excuse me folks . I believe the numbering got assigned as the databases design started to evolve. They had to have some numbers , so the best was to...

November 22, 2017 at 8:39 am

#1969189
RE: Why SQL Server is not using non-clustered index

Since it does cost based optimization , based on 'estimates' SQL decides to go with the least costly plan. Depending upon , say , how stale are the stats...

November 22, 2017 at 8:25 am

#1969184
RE: SQL server restart

Thanks Gail and Eirikur. My question is answered.

November 20, 2017 at 11:21 am

#1968833

Viewing 15 posts - 106 through 120 (of 335 total)