Viewing 15 posts - 2,296 through 2,310 (of 7,499 total)
If you want to, you can just post the execution plan and we'll see what we can come up with 🙂
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2011 at 3:44 pm
this is one of the misconceptions of sqlserver temp objects.
- http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-myths-debunked-part-1/
- http://www.scarydba.com/2009/10/13/table-variables-are-only-in-memory-fact-or-myth/
There is another forum thread with the same question:
http://www.sqlservercentral.com/Forums/Topic923309-146-1.aspx
and of course there is an article at SSC:
http://www.sqlservercentral.com/articles/Temporary+Tables/66720/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2011 at 3:14 pm
how about just creating an audit ddl trigger.
Be sure to cover that with a server event in case the trigger is disabled.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2011 at 3:08 pm
Just use a scheduled sqlagent job that runs your script for every userdb.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2011 at 3:05 pm
I advise to just talk to your sysadmin/dba and request what you want.
They will most likely be glad to point you to the request procedure or eventually the implemented segregation...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2011 at 3:03 pm
You cannot.
- #tablename temp tables are cleaned up after the connection closes.
- ##tablename (global temporary tables) can only be dropped if they are no longer used by an active connection.
What...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 22, 2011 at 1:30 pm
primitive but working ....
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server
Imports System.Management
Partial Public Class UserDefinedFunctions
<Microsoft.SqlServer.Server.SqlFunction()> _
Public Shared Function ufn_GetOSStartUpTime() As SqlDateTime
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 22, 2011 at 3:43 am
I didn't find it in sys.dm_os at a first glance ...
so here are some examples of how you can do it with WMI and/or Powershell
http://social.technet.microsoft.com/Forums/en-GB/ITCG/thread/c4e577d3-ee7f-42a7-83da-375361d56bde
Integratable in CLR...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 22, 2011 at 12:50 am
GilaMonster (2/21/2011)
GSquared (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
WayneS (2/20/2011)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 22, 2011 at 12:22 am
YSLGuru (2/21/2011)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 22, 2011 at 12:12 am
Another ref to put in the "must read" section !
Very good job !
Is there already a "sql server db logs / recovery models " section in SSC Stairways[/url]?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 21, 2011 at 1:30 am
It depends 😉
For investigation / development I use SSMS and TSQL.
I have a script library which I built over time, so starting from there I'm fairly at ease.
With SSMS...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 21, 2011 at 12:50 am
just a quick copy/paste from my script library:
-- how to determin SQLServer Uptime
-- zie Tracking Uptime by Brian Moran http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html
--
-- dd 20060912 JOBI - aangepast voor SQL2005 (DMV)
--
--...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 20, 2011 at 2:46 pm
Indeed, interpreting the install log files is a PITA for everybody.
the error messages start before the registration errors you posted.
And yes, the timeout messages mostly are a result of another...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 20, 2011 at 11:49 am
IMO schema can be used in at least two ways:
- to outline data collections cfr Adventureworks db
(not coupled to an application !)
- to ease...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 20, 2011 at 10:27 am
Viewing 15 posts - 2,296 through 2,310 (of 7,499 total)