Viewing 15 posts - 4,801 through 4,815 (of 19,560 total)
The best solution for that problem is good documentation. You need to know where the packages are being stored and what processes use said packages.
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 25, 2013 at 10:16 pm
Is this a newer physical server that you have SQL installed on?
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 25, 2013 at 9:03 pm
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
March 25, 2013 at 6:23 pm
SELECT name
FROM sys.databases
WHERE database_id <= 4
/*
Report Services where collation has not been changed from default
Inclusion of SSRS dbs is questionable as system databases
*/
OR (name LIKE '%ReportServer%'
AND collation_name = 'Latin1_General_CI_AS_KS_WS')
/*
Catch...
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 23, 2013 at 9:37 am
Along the same vein as Grant started:
Who does the performance tuning for your SQL Server (tsql etc)?
That will give you a lot more experience
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 23, 2013 at 8:51 am
opc.three (3/23/2013)
gantavasu (3/23/2013)
Here i have configured the mirroring. after that i want to add the data file to primary.
can we add the data file?
if we add is there any impact...
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 23, 2013 at 8:47 am
Generally, I'd opt for a single update statement. If that means retyping the calculations for dependent columns - so be it. You create a stored procedure and your...
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 23, 2013 at 1:17 am
It largely depends on what your future plans are. If you intend to continue with SQL Server or with creating reports in SQL Server - then the experience should...
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 23, 2013 at 1:14 am
ijtroquim (3/22/2013)
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 22, 2013 at 11:57 pm
Eric M Russell (3/21/2013)
Eric M Russell (3/21/2013)
majorbloodnock (3/21/2013)
What I'd like to know is how much the sum of human knowledge has grown in the same time.. . .
Good point.
...
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 22, 2013 at 11:51 pm
Here we are talking about the massive storage and where it might be in 10 yrs or so. I am sitting on the other hand thinking that these large...
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 22, 2013 at 11:40 pm
Steve Jones - SSC Editor (3/22/2013)
That's easy to script.
loop through all tables in all databases, grant...
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 22, 2013 at 10:48 pm
Use stored procedures for any jobs and store the stored procedure in SVN
or
Script the job as a drop create and store that statement in SVN.
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 22, 2013 at 12:24 pm
crookj (3/22/2013)
Stuart Davies (3/22/2013)
L' Eomot Inversé (3/22/2013)
Revenant (3/22/2013)
Terry300577 (3/22/2013)
YeggScrambled Yeggs
Not permitted in the USA: scambling a Yegg would be a cruel and unusual punishment.
True - but they might deserve it
May...
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 22, 2013 at 12:22 pm
Thanks Ron
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 22, 2013 at 12:20 pm
Viewing 15 posts - 4,801 through 4,815 (of 19,560 total)