Viewing 15 posts - 2,296 through 2,310 (of 7,502 total)
If I'm correct you need middleware for SQL2005.
With SQL2008 MS did aquire that middleware.
Now, if only I could recall the exact name.
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 24, 2011 at 1:31 pm
the log can only grow because of database activity.
log entries will only be truncated at the end of a log backup (see Gails previous replies)
So even if the tape is...
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 24, 2011 at 12:58 pm
Lowell (2/24/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 24, 2011 at 6:48 am
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
Viewing 15 posts - 2,296 through 2,310 (of 7,502 total)