Viewing 15 posts - 8,041 through 8,055 (of 49,552 total)
er.mayankshukla (8/20/2014)
I have searched a lot but didn't got a proper response.
If specifying Compression option in Create Table statement means an automatic compression in the table, then what will the...
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
August 20, 2014 at 6:50 am
Please don't start new threads for existing questions.
Replies to http://www.sqlservercentral.com/Forums/Topic1605321-391-1.aspx please.
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
August 20, 2014 at 6:12 am
Please post the full and complete, unedited output of that CheckDB command.
DO NOT do anything else at this point. Please note that the advice given in the thread linked above...
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
August 20, 2014 at 5:48 am
Depends whether you specify compression in the rebuild statement.
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
August 20, 2014 at 2:56 am
protix (8/20/2014)
GilaMonster (8/19/2014)
How many transactions/sec are you talking here? What hardware? What are your current bottlenecks?
About 500/sec long term average and 1500/sec peak, the bigger part reading.
Hardware is on on...
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
August 20, 2014 at 2:55 am
MJ-1115929 (8/20/2014)
1) In which situation we De-normalize a database?
Once you have tested thoroughly and have determined that there is no way to meet performance requirements without denormalising. It's a...
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
August 20, 2014 at 2:45 am
arrjay (8/20/2014)
Can I assume that TDE is 128;
Only if you set it to use 128. I'll repeat part of my previous post.
"As part of creating a database encryption key (for...
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
August 20, 2014 at 2:43 am
Depends on what you set it to.
From Books Online (http://msdn.microsoft.com/en-us/library/bb934049.aspx)
To use TDE, follow these steps.
Create a master key
Create or obtain a certificate...
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
August 20, 2014 at 2:31 am
Escape the quote by doubling it
LEFT(LastName,2) = 'O''' -- That's two single quotes to escape the ', then a third one to close the string
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
August 20, 2014 at 2:28 am
They're probably database owner or sysadmin.
New questions in new thread please.
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
August 19, 2014 at 4:18 pm
smtzac (8/19/2014)
Log file size right now 100 GBBig translation took place, size of 125 GB.
would the Log file size be 100+125 = 225 GB ?
Depends how much of that existing...
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
August 19, 2014 at 9:54 am
Could be a case of blaming the database for an error without investigating.
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
August 19, 2014 at 9:05 am
Errr.... First time I've heard that.
Could you ask that person for the kb article for that 'confirmed microsoft limitation'?
According to Books Online (http://msdn.microsoft.com/en-us/library/ms188365.aspx)
BULK INSERT (Transact-SQL)
Imports a data file...
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
August 19, 2014 at 8:42 am
smtzac (8/19/2014)
Yes it does, some time Transaction log file (backup from Log shipping) is 100+...
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
August 19, 2014 at 8:30 am
smtzac (8/19/2014)
I like to make log file size to 20-25 GB so I can make extra free space on hard drive.
Why?
Do you need the space for some other database?...
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
August 19, 2014 at 7:46 am
Viewing 15 posts - 8,041 through 8,055 (of 49,552 total)