SQLRNNR

Forum Replies Created

Viewing 15 posts - 226 through 240 (of 19,560 total)

RE: Grant Execute Permission on sp_audit_write

David Bird - Friday, March 31, 2017 11:50 AM
I got "sp_audit_write" working but only with ids granted to SYSADMIN. Looking at Microsoft...
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

March 31, 2017 at 12:02 pm

#1936049
RE: What do you do to relax after work?

lptech - Friday, March 31, 2017 10:23 AM
One of the P90X workouts as soon as I get home. That way, no excuses...
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

March 31, 2017 at 11:53 am

#1936047
RE: What do you do to relax after work?

bkubicek - Friday, March 31, 2017 6:43 AM
WayneS - Friday, March 31, 2017 6:41 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

March 31, 2017 at 11:52 am

#1936046
RE: It Just Runs Faster - Spatial

Excellent question. I like to learn about the performance enhancements in 2016.
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

March 31, 2017 at 11:42 am

#1936043
RE: Embedded SQL Server 2008 Workgroup license mobility

If moving the license, I must caution that it is imperative to remove the license from the old box or shut it down completely. Not doing so would require the...
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

March 31, 2017 at 11:36 am

#1936041
RE: Need SQL Training Recommendations

Grant Fritchey - Friday, March 31, 2017 5:29 AM
One more book suggestion,and it's a free one if you download it:
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

March 31, 2017 at 11:33 am

#1936040
RE: Proper way to remove columns from source

cpeck - Friday, March 31, 2017 6:36 AM
No, when I remove the two columns altogether from everywhere, the query hangs upon trying...
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

March 31, 2017 at 11:31 am

#1936038
RE: Embedded SQL Server 2008 Workgroup license mobility

peter 98284 - Thursday, March 30, 2017 5:25 PM
we would install it on EC2 instance running Windows Server 2008, 2008 R2 or...
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

March 31, 2017 at 11:29 am

#1936036
RE: Embedded SQL Server 2008 Workgroup license mobility

peter 98284 - Thursday, March 30, 2017 4:04 PM
We have an application (GoldMine 2014) that came with SQL 2008 Workgroup. We need...
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

March 30, 2017 at 5:13 pm

#1935890
RE: SSRS 2012 to 2016 Upgrade - Recreating Subscriptions

Nadrek - Thursday, March 30, 2017 3:25 PM
I've just restored the previous server's ReportServer database to the new server and all the...
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

March 30, 2017 at 5:05 pm

#1935888
RE: The U-SQL SQL.MAP

Revenant - Thursday, March 30, 2017 4:13 PM
SQLRNNR - Thursday, March 30, 2017 4:03 PM
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

March 30, 2017 at 5:02 pm

#1935886
RE: DB MAXDOP Settings

Ken Wymore - Tuesday, March 21, 2017 8:00 AM
Cool option. Yet another reason to upgrade to 2016.
Agreed. This is very beneficial.
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

March 30, 2017 at 4:11 pm

#1935881
RE: Multiple TCP Ports

Good question. Lets have a few more like this.
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

March 30, 2017 at 4:10 pm

#1935880
RE: A full and a diff

Jeff Moden - Thursday, March 16, 2017 7:18 AM
Heh... for me, the correct answer for me is there would be no files...
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

March 30, 2017 at 4:06 pm

#1935879
RE: SSMS Tricks - Results

Probably my second most frequently used keyboard shortcut - right after alt-x.
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

March 30, 2017 at 4:05 pm

#1935878

Viewing 15 posts - 226 through 240 (of 19,560 total)