Phil Parkin (7/5/2016)

---

tindog (7/5/2016)

---

Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a colleague...

Chitown (7/5/2016)

---

I have a DB with 64 GB of logfile. I shrunk the logfile to 20 GB, took a full backup. Backup file is 216 GB. I have 259 GB...

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a colleague in London who's looking at New...

dclemens (7/5/2016)

---

I've taken over a production SQL server (2008 R2 Enterprise) and upon doing my checklist I've uncovered that TempDB currently has 4 files (2) 10500MB and (2) 7500MB.

I'd like...

It looks like the existing SQL service account, or the account that is doing the installation, does not have enough rights to the files and folders.

Also, run the administrator as...

The Import \ Export wizard only looks at the first 50 rows for the transformations or previews.

If you think about it, attempting to analyze an entire data set to cover...

Ed Wagner (6/29/2016)

---

djj (6/29/2016)

---

jasona.work (6/29/2016)

---

Oh the fun of the last couple days before a long holiday weekend...

Everyone who could, took time off, those that are left (me!) work on things...

Do you have a third part backup running in addition to the native SQL backups?

There's where the weird filenames are coming from.

Try running this query and see if it shows...

Create a job that runs at startup of SQL Server.

Put the following, after changing the values specific to you, in the job.

DECLARE @ServerName AS NVARCHAR(200) = 'Possible Failover of '...

SharePoint is not the most efficient application. The results from sp_blitz are normal.

Freeing the cache is not going to do much.

Have you captured the file growths on...

Not unusual for Sharepoint.

https://technet.microsoft.com/en-us/library/ff945791.aspx

https://blogs.technet.microsoft.com/sqlpfeil/2012/07/14/four-tips-for-sql-tuning-for-sharepoint-part-3-tempdb/

There are a lot more, google it!

Did you set maxdop = 1?

Have you turned on trace flag T1117 and T1118?

1. Create the table

2. Use BCP and specify the field terminator as the "|||"

A possible command, fill in the blanks to fit your environment

BCP Database.Schema.Table IN C:\bcp\ImportThis.txt /m 100 /b...

Not sure that I ever had a database server get a case of the hiccups!

My opinion would be to find the root cause, and fix that. Putting in a...

ram302 (6/16/2016)

---

Hi all,

I was wondering how to monitor a database to ensure it's up. I have scripts that perform stored procedure executions and they already check to make sure the...

Lynn Pettis (6/16/2016)

---

Michael L John (6/16/2016)

---

I'm sorry, this post infuriates me.

Integer division was taught within the first three weeks of my first programming class in my first semester of...