Viewing 15 posts - 4,231 through 4,245 (of 7,164 total)
A Trace (accessible via Profiler or server-side trace) can be thought of as a logging mechanism for SQL Server. Using SQL Trace
Since you're on SQL Server 2008 you could also...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 11:45 am
In an adjacency list a child typically has one parent. I think in the OPs model a child can have multiple parents, in which case the permutations when traversing the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 11:38 am
You're welcome! Thanks for posting back, confirming that it worked!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 11:30 am
32-bit or 64-bit?
How does selecting data from an Excel Workbook fit into your overall process, i.e. what are you trying to accomplish?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 11:08 am
Microsoft® SQL Server® 2008 R2 Best Practices Analyzer is a good place to start.
Monitoring Best Practices by Using Policy-Based Management has a bunch of useful checks as well. PBM is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 10:00 am
SQL Kiwi (5/1/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 8:36 am
Dev (5/1/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 8:19 am
pamozer (4/30/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 10:36 pm
How to: Uninstall an Existing Instance of SQL Server (Setup)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 10:27 pm
You could keep a list of logins hardcoded in the trigger as the example shows, or as I said you would need to keep them in a separate table. Having...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 9:24 pm
capn.hector is correct too (we were typing at the same time so didn't see his post)...I do not expect issue with an in-place upgrade, but a fresh slate is always...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 8:43 pm
Sapen (4/30/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 8:41 pm
NaCl (4/30/2012)
•Have distinct owners for databases; not all databases should be owned by sa
i understand the advantage of ownership by an account that...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 3:24 pm
capn.hector (4/30/2012)
GSquared (4/30/2012)
Standard Edition can use 64GB of RAM in 2008 R2. Ref: http://download.microsoft.com/download/F/F/C/FFC6D450-A0A2-4916-80EA-B83F7BCDF250/SQLServer2008R2EditionsDatasheet_Aug10%5B1%5D.pdf
The OP was talking about Windows Server not SQL Server being the limiting factor the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 2:09 pm
I do not see EXEC(@MyString) in your proc.
Also, to clarify, make sure you have a GO after your proc definition when compiling to make sure you do not include anything...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 30, 2012 at 2:07 pm
Viewing 15 posts - 4,231 through 4,245 (of 7,164 total)