Viewing 15 posts - 4,306 through 4,320 (of 49,571 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...
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...
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.
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?
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...
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...
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...
November 11, 2015 at 11:09 am
Try setting up an Extended Events session.
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...
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...
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...
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...
November 11, 2015 at 6:21 am
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...
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...
November 11, 2015 at 12:50 am
Viewing 15 posts - 4,306 through 4,320 (of 49,571 total)