Arsh

Forum Replies Created

Viewing 15 posts - 181 through 195 (of 342 total)

RE: Column Length

Thanks Eric. Yeah the idea of not consuming the space is clear ,as per other posts too .The overhead of SQL spending resources in allocating n de-allocating the space from...

September 25, 2017 at 10:50 pm

#1960879
RE: Can't Shrink TEMPDB

alex.sqldba - Monday, September 25, 2017 1:16 AM
It was built with the Installers recommended/default -- the number of files match the number...

September 25, 2017 at 6:19 am

#1960706
RE: Column Length

Thanks so much Scott.Got it.

September 23, 2017 at 2:34 am

#1960614
RE: Server isn't reachable

Bill Talada - Friday, September 22, 2017 6:01 AM
Usually, a second instance (not the default) can be set to get a dynamic...

September 22, 2017 at 6:29 am

#1960474
RE: Integer Data Types

John Mitchell-245523 - Friday, September 22, 2017 1:42 AM
https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql
John
Thanks John.

September 22, 2017 at 6:25 am

#1960472
RE: Column Length

Thank you John,Anthony and all others for clarification on the question.Thanks.

September 21, 2017 at 10:04 am

#1960392
RE: Column Length

Thank you ZZartin and John . I think I didn't keep my question clear . Narrowing it down ..... Will SQL load the memory with empty spaces/memory-holes when it...

September 21, 2017 at 8:42 am

#1960377
RE: Column Length

John Mitchell-245523 - Thursday, September 21, 2017 7:32 AM
Not necessarily, no. It depends whether your column is variable width (varchar(n), for example),...

September 21, 2017 at 7:46 am

#1960362
RE: Column Length

John Mitchell-245523 - Thursday, September 21, 2017 5:55 AM
The wider your column, the fewer rows you#ll fit on a single data page...

September 21, 2017 at 7:22 am

#1960359
RE: disk space after deleting records.

sgmunson - Wednesday, September 20, 2017 2:41 PM
newdba2017 - Wednesday, September 20, 2017 12:02 PM

September 21, 2017 at 5:31 am

#1960339
RE: SQL Server Mirroring Issue

rohitsinghchauhan71 - Wednesday, September 20, 2017 11:28 PM
That means my Endpoint is redirected to SQL Server Express edition Instance. So I...

September 21, 2017 at 5:23 am

#1960338
RE: Procedure to upgrade SQL Server on same server

Well, could see only two options - You script / backup all the required stuff (which I believe you are well aware of ) manually , or use a...

September 21, 2017 at 5:16 am

#1960336
RE: Configuring SQL server buffer

Thank u Eirikur.

September 21, 2017 at 5:11 am

#1960335
RE: Memory Ring Buffers

Thank you Sue.

September 21, 2017 at 5:10 am

#1960334
RE: view time out

tomashons - Tuesday, September 19, 2017 9:55 AM
Hello there is solution:
Run -> regedit -> Computer\HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0(or 14.0 depends on...

September 19, 2017 at 10:44 am

#1960000

Viewing 15 posts - 181 through 195 (of 342 total)