SQLRNNR

Forum Replies Created

Viewing 15 posts - 5,641 through 5,655 (of 19,560 total)

RE: SSIS Package Fails

Does the package run from within bids?
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

September 12, 2012 at 5:07 pm

#1536957
RE: CS Collation

Guacamole
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

September 12, 2012 at 7:45 am

#1536714
RE: SQL Server Jobs issue

You can set an alert to text or email you.
You can also create a job that checks for any failed jobs and then emails job results to you.
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

September 11, 2012 at 9:24 pm

#1536549
RE: DMV to get CPU information by query

FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt
Within sys.dm_exec_sql_text there is a dbid field. Use the db_name() function to get the name of the database.
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

September 11, 2012 at 8:00 pm

#1536542
RE: SSIS Package Fails

Does the sql server agent service account have permissions to the folder where the excel file resides?
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

September 11, 2012 at 7:22 pm

#1536538
RE: Meredith Ryan Chosen as the Exceptional DBA of 2012

Congrats Meredith!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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

September 11, 2012 at 5:50 pm

#1536533
RE: DMV to get CPU information by query

CPU is total_worker_time in that DMV
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

September 11, 2012 at 4:18 pm

#1536525
RE: Report Naming Standards!!!?

The best thing you can do there is to do what you think makes logical sense --- after discussing it with interested parties. It needs to make sense to...
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

September 11, 2012 at 4:01 pm

#1536520
RE: Should I configure the second sql instance to use same C:\ drive root directory path as the exiting Default instance?

The instance will function just fine.
I like to move my default path off of C in the first place. I also like to have a different path for each...
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

September 11, 2012 at 3:58 pm

#1536518
RE: Administration

SQL Kiwi (9/11/2012)
The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and...
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

September 11, 2012 at 3:56 pm

#1536516
RE: T-SQL

Lynn Pettis (9/10/2012)
Just a note, I try to write all my code as if the database was case sensitive. If a table is named ZipCode, then that is how...
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

September 10, 2012 at 10:58 am

#1535823
RE: Are the posted questions getting worse?

Lynn Pettis (9/7/2012)
Okay, an etiquette question as a Good Samaritan. How many times should you refuse money for helping a motorist with a disabled vehicle? I was walking...
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

September 7, 2012 at 5:59 pm

#1535345
RE: GO Part 1

Thanks for the question.
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

September 7, 2012 at 11:10 am

#1535193
RE: Are the posted questions getting worse?

jasona.work (9/7/2012)
Ah, the feeling you get when you do something for yourself, from scratch, without finding someone elses' code to use...
Even if it is something that a seasoned DBA (not...
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

September 7, 2012 at 10:47 am

#1535179
RE: Ridiculous

Lynn Pettis (9/7/2012)
TravisDBA (9/7/2012)
majorbloodnock (9/7/2012)
TravisDBA (9/7/2012)
It has been my experience at events like this that if security personnel do not directly see it happen, or on closed circuit camera, then...
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

September 7, 2012 at 10:45 am

#1535176

Viewing 15 posts - 5,641 through 5,655 (of 19,560 total)