Viewing 15 posts - 2,041 through 2,055 (of 49,552 total)
Sqlsavy (11/29/2016)
Is it possible roughly to calculate size of the database based on just the details that I've provided?
No.
18 million rows means nothing when a row can be anything from...
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
November 29, 2016 at 7:12 am
You shouldn't be using the sa account at all. If Veeam requires login and password then, after checking the authentication modes as Paul suggested, create a new account for Veeam...
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
November 29, 2016 at 4:19 am
Such as?
Asking because I'm not sure I understand what you're after.
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
November 29, 2016 at 3:54 am
Steve Jones - SSC Editor (11/28/2016)
My daughter grinds beans each morning for her french press and froths milk. She usually makes enough to give me a cup 😉
I have 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
November 28, 2016 at 12:17 pm
Developer Edition is free (for dev/test only). https://www.visualstudio.com/dev-essentials/
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
November 28, 2016 at 5:54 am
Do you have a DBA there?
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
November 28, 2016 at 2:54 am
Indianrock (11/25/2016)
I've emailed my manager about the possibility of bringing in a consultant.
If you don't mind working with someone on another continent (I'm in South Africa), I don't have 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
November 26, 2016 at 2:00 am
fabriziodb (11/24/2016)
hi, i'm evaluating some full-text tool, i read that full-text need to be installed in sql server 2016, it is missing in default installation.
It's been an optional feature since...
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
November 24, 2016 at 10:06 am
BLOB EATER (11/24/2016)
GilaMonster (11/24/2016)
Brandie Tarvin (11/24/2016)
Much prefer chocolate or herbal tea (decaf).
The office kitchen also caters to stranger tastes, with 3 types of tea (two black tea variants and rooibos),...
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
November 24, 2016 at 10:02 am
Brandie Tarvin (11/24/2016)
Much prefer chocolate or herbal tea (decaf).
The office kitchen also caters to stranger tastes, with 3 types of tea (two black tea variants and rooibos), Milo and hot...
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
November 24, 2016 at 5:54 am
BLOB EATER (11/24/2016)
GilaMonster (11/23/2016)
robert.sterbal 56890 (11/23/2016)
What is on your menu for Thanksgiving?Office coffee and probably a sandwich for lunch from one of the nearby shops.
This is my lunch everyday. I...
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
November 24, 2016 at 5:27 am
It occurs when threads busy with full text operations wait for synchronisation.
https://www.sqlskills.com/help/waits/ft_iftshc_mutex/
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
November 24, 2016 at 3:07 am
TRUNCATE TABLE
DROP TABLE/CREATE TABLE
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
November 24, 2016 at 2:41 am
Any database on that server have Full Text Indexing enabled on it?
It's in Glenn's list of benign waits to ignore, so I'd just ignore it (lots of waits should be...
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
November 24, 2016 at 2:38 am
robert.sterbal 56890 (11/23/2016)
What is on your menu for Thanksgiving?
Office coffee and probably a sandwich for lunch from one of the nearby shops.
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
November 23, 2016 at 2:20 pm
Viewing 15 posts - 2,041 through 2,055 (of 49,552 total)