Viewing 15 posts - 151 through 165 (of 313 total)
Steve Jones - SSC Editor (9/25/2014)Something created lots of log records, so you'd have to find a lot of data changes or inserts. (or maintenance).
Check for those things
How do I...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 25, 2014 at 3:11 pm
ErrLog (9/22/2014)Do you use Remedy? - ARsystem - lol :).
Yes
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 22, 2014 at 10:20 am
Please see the attachment. Like I said, I didn't start any trace nor did I schedule any trace job.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 22, 2014 at 10:08 am
Luis Cazares (9/9/2014)
On a server? Are you serious?:w00t:
Yes on the server. I asked one of co-worker to RDP into the server and kick me out but he ended up getting...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 9, 2014 at 10:28 am
Luis Cazares (9/5/2014)
CREATE TABLE dbo.TraceResults(
TextData nvarchar(max) NULL,
ApplicationName nvarchar(256) NULL,
NTUserName nvarchar(256) NULL,
LoginName nvarchar(256) NULL,
CPU int NULL,
Reads bigint NULL,
Writes bigint NULL,
Duration...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 5, 2014 at 11:03 am
Grant Fritchey (9/4/2014)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 4, 2014 at 1:14 pm
I ran a profiler and selected Standard template and then save that to a file and this is what I have.
This is what I need help with:
How do I get...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 4, 2014 at 11:38 am
GilaMonster (8/7/2014)
What does "Creating an index within the application" even mean?
No Idea. I wanted to ask him the same thing, but I didn't. I don't know if this is something...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
August 7, 2014 at 1:17 pm
Grant Fritchey (7/31/2014)
So, you're employer isn't likely to spring for a trip to Belgium then. Oh well. There's still Connections and PASS Summit.
Well we do have an open door policy...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 31, 2014 at 9:02 am
Grant Fritchey (7/31/2014)
Oh, and if you are in Europe, I'm doing a full day on execution plans at SQL Server Days.
I live in Chicago, IL
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 31, 2014 at 8:42 am
ScottPletcher (7/22/2014)
I have also done some stuff to improve performance by creating appropriate indexes and by changing the way queries are written.
I think that's one of the most value-added and...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 22, 2014 at 11:24 am
GilaMonster (7/22/2014)
New Born DBA (7/22/2014)1) I haven't set up any alerts on the system since all the alerts are in place?(I am hoping that they are in place, but have...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 22, 2014 at 10:25 am
Thanks everybody for taking their time out and helping me. There are tons of things I need to learn and most of you guys have suggested me with some amazing...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 22, 2014 at 9:26 am
GilaMonster (7/22/2014)Not what I asked.
Have you set up alerts on your systems?
Have you set up automated restore tests?
Have you set up job monitoring?
Aaha! of course this is not what you...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 22, 2014 at 8:47 am
Grant Fritchey (7/22/2014)
Learn PowerShell.Automate all the things.
Would love to, but where should I start?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 22, 2014 at 8:36 am
Viewing 15 posts - 151 through 165 (of 313 total)