Viewing 15 posts - 9,466 through 9,480 (of 19,560 total)
Before going down that rabbit hole, check out this article.
http://jasonbrimhall.info/2010/07/07/sql-2008-dts/
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
July 7, 2011 at 2:48 pm
Like Gus said, it depends on Business needs and any regulations that may affect your business. I have worked in shops where we were required to save backups for...
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
July 7, 2011 at 2:04 pm
How is your instance configured? Are you using the default port? Is this is a default instance installation? Did you open the ports for all of relevant...
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
July 7, 2011 at 1:54 pm
Change to this:
SET @sql = 'USE '+@db_name+'go; insert into [youradmindbname].[dbo].[Table_Dependency]([nam],[type]) EXEC sp_depends '+@table_name
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
July 7, 2011 at 1:39 pm
anjaliv (7/7/2011)
I am trying the same for sp_depends. Do you think following would work?
SET @sql = 'insert into [dbo].[Table_Dependency]([nam],[type]) EXECUTE USE '+@db_name+' EXEC sp_depends '+@table_name
EXEC...
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
July 7, 2011 at 1:05 pm
You would need to write the data out to file. If you encrypt the data in the file, you would need to pass your key to decrypt the 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
July 7, 2011 at 12:55 pm
Here is an alternative to that as well.
http://jasonbrimhall.info/2010/05/25/space-used/
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
July 7, 2011 at 12:42 pm
kutemom09 (7/7/2011)
Crystal is not case sensitive.I checked with my manager as he is the one who does reporting.
If SQL is not CS, and you have altered the default behavior of...
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
July 7, 2011 at 12:35 pm
sqlfriends (7/7/2011)
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
July 7, 2011 at 12:00 pm
I would go TFS or SVN depending on funding. Both are good IMHO.
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
July 7, 2011 at 11:28 am
Just bootcamp, or should we include tech school too?
If that bootcamp was on par with Internals training by SQLSkills, I would say yes. If that bootcamp is on par...
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
July 7, 2011 at 11:27 am
coronaride (7/7/2011)
I've reinstalled the client tools about 3 times now.
After uninstall of same tools?
If so, there may be something else running that is conflicting with the tools. What other...
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
July 7, 2011 at 11:25 am
kutemom09 (7/7/2011)
We use crystal reporting to genarate report
Crystal reports is case sensitive. In order to get around that, you have to use the upper or lower sql functions. ...
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
July 7, 2011 at 11:24 am
I agree that numbers are an essential measure to discover progression/regression. I like that the concept of different numbers/measures for different jobs is essential. You can't use 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
July 7, 2011 at 11:19 am
Steve Jones - SSC Editor (7/7/2011)
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
July 7, 2011 at 11:14 am
Viewing 15 posts - 9,466 through 9,480 (of 19,560 total)