SQLRNNR

Forum Replies Created

Viewing 15 posts - 346 through 360 (of 19,560 total)

RE: How to determine Windows domain username when the user connected to SQL as SQL login with SA access

If they are using a SQL login, it will not map to a domain login.
What you could do is log the user, ip and hostname with a timestamp...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 27, 2017 at 3:21 pm

#1930575
RE: Today's Random Word!

Ed Wagner - Monday, February 27, 2017 9:20 AM
Hugo Kornelis - Monday, February 27, 2017 8:11 AM
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 27, 2017 at 3:17 pm

#1930574
RE: Are the posted questions getting worse?

Ed Wagner - Monday, February 27, 2017 9:55 AM
Eirikur Eiriksson - Monday, February 27, 2017 9:47 AM
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 27, 2017 at 11:50 am

#1930522
RE: DBCC PAGE

TomThomson - Monday, February 27, 2017 6:41 AM
With the introduction of sys.dm_db_database_page_allocations in SQL Server 2012 we probably shouldn't be using DBCC...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 27, 2017 at 9:44 am

#1930502
RE: Are the posted questions getting worse?

Ed Wagner - Monday, February 27, 2017 9:22 AM
As if the hacks and breaches aren't enough, now we have employees pulling a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 27, 2017 at 9:35 am

#1930499
RE: Are the posted questions getting worse?

Koen Verbeeck - Wednesday, February 1, 2017 3:03 PM
Happy, delighted, humbled and overall gleeful to announce that I'm awarded the Microsoft Data...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 26, 2017 at 11:06 pm

#1930417
RE: Are the posted questions getting worse?

Jeff Moden - Wednesday, December 7, 2016 7:02 AM
This Saturday, 12/10, marks the anniversary of a very unhappy event for me....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 26, 2017 at 10:32 pm

#1930413
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Tuesday, November 22, 2016 9:50 AM
Have to drop this here, since I'm proud.My son completed his...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 26, 2017 at 10:21 pm

#1930411
RE: Are the posted questions getting worse?

Chad Crawford - Friday, October 28, 2016 1:32 PM
Well, the summit has been good to me this year. I participated...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 24, 2017 at 7:44 pm

#1930299
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, October 20, 2016 8:16 AM
Brandie Tarvin (10/20/2016)
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 24, 2017 at 7:40 pm

#1930298
RE: Are the posted questions getting worse?

Sean Lange - Thursday, October 13, 2016 7:49 AM
WOW...http://www.sql-datatools.com/2016/05/sql-queries-tuning-and-optimization.htmlThis is supposed to be a list of things to do to optimize queries....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 24, 2017 at 7:32 pm

#1930297
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, October 12, 2016 7:55 AM
Sean Lange (10/12/2016)
Grant Fritchey (10/12/2016)
jasona.work (10/12/2016)
Now this sounds like it has an interesting story...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 24, 2017 at 7:27 pm

#1930296
RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, October 11, 2016 1:26 PM
Ever get the feeling that you are being used to do someone else's job...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 24, 2017 at 7:24 pm

#1930295
RE: Find Stored Proc name from ObjectId in Profiler

That may be a safe assumption. Before accepting the assumption that it is not a proc, rerun your query against sys.all_sql_modules.
You could also query sys.objects for the objectid in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 24, 2017 at 1:17 pm

#1930264
RE: Roll from lowest level child to it's subsequent parent

I recommend you have a look at this article by Wayne Sheffield
http://blog.waynesheffield.com/wayne/archive/2011/08/running-totals-in-denali-ctp3/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

February 24, 2017 at 1:12 pm

#1930261

Viewing 15 posts - 346 through 360 (of 19,560 total)