Viewing 15 posts - 4,306 through 4,320 (of 49,552 total)
Duplicate post. No replies here please.
http://www.sqlservercentral.com/Forums/Topic1735989-3077-1.aspx
Also, we don't do people's homework for them. I don't need to practice basic T-SQL, and you won't learn anything by having someone else do...
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 12, 2015 at 7:06 am
BrainDonor (11/12/2015)
I see a lot of customers who register email addresses that are unique for this site.
You can also do things like
myname+sitename@<domain> (or maybe the other way around). GMail supports...
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 12, 2015 at 6:14 am
SP:StmtCompleted will show statements executing within a procedure. Be careful of filters, they're the most common reason why events don't show up.
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 12, 2015 at 5:17 am
Have you fixed the corruption in the DB, or did you just stop reindexing that database?
And what the hell does VMWare do that causes database corruption?
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 12, 2015 at 5:15 am
STOPAT is supported on full and diff restores only so that you can specify consistent options on all of your restore statements to reduce the chance of mistakes. To restore...
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 12, 2015 at 5:06 am
sgrimard (11/11/2015)
Should I create all the proposed missing index by the SQL Execution Plan?
NO! Absolutely not.
The suggestion is based solely on that single query and it the single, absolute best...
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 11, 2015 at 12:53 pm
Profiler, no. Hence the explicit suggestion of XE only.
Just dive in. It's got a GUI in 2012, create new session and look around (or read Jonathan's XE series on his...
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 11, 2015 at 11:09 am
Try setting up an Extended Events session.
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 11, 2015 at 10:53 am
To be utterly blunt, that's days worth of work that you're asking people to give you for nothing. Prepping training courses takes a lot of time. Prepping labs takes even...
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 11, 2015 at 10:50 am
MotivateMan1394 (11/11/2015)
Hi professionalsI want to Separate User Object File Group from System Objects File Group
1- Is this effective for IO Performance ?
No.
And what about another objects : stored Procedures...
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 11, 2015 at 6:35 am
Try removing this column:
[TimeTaken] AS (datediff(second,[StartDateTime],[EndDateTime])) PERSISTED
It's complaining about a computed column, so unless you really, really need that in the table and not calculated in a query, removing...
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 11, 2015 at 6:26 am
Just so I'm clear, you want someone to give you the contents for a course, along with demo code, labs for people to do? I get the impression from your...
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 11, 2015 at 6:21 am
http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
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 11, 2015 at 6:19 am
david.alcock (11/11/2015)
Hekaton does have a rather impressive list of limitations to its usage, those need checking prior to implementing.
Yes, but to be clear, most of those limitations are for natively...
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 11, 2015 at 2:08 am
nickm_GR (11/10/2015)
I was having a conversation with our infrastructure guy, and he kept saying "Well, everything is going to be on FLASH anyway, so it really doesn't matter".
"Everything going...
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 11, 2015 at 12:50 am
Viewing 15 posts - 4,306 through 4,320 (of 49,552 total)