Viewing 15 posts - 526 through 540 (of 1,081 total)
Do you receive the alerts in the same time period each day?
Setup a trace in profiler and some perfmon capturing for that time frame to see where and when your...
March 15, 2011 at 11:54 pm
GilaMonster (3/15/2011)
In clustering the two nodes should be identical. That's hardware, OS, drivers, etc. Clustering a physical box with a virtual is definitely not having two identical nodes.
Correct, although a...
March 15, 2011 at 3:38 am
GilaMonster (3/15/2011)
If you're thinking about a blog, try writing blog-type posts for 2 or...
March 15, 2011 at 3:07 am
GilaMonster (3/15/2011)
Write about what excites you. If writing is a chore, it will show
Makes 100% sense. Are there any collaborative blog spots where DBA's/Dev's can compose write-ups in a joint...
March 15, 2011 at 2:34 am
Just stay on SSC, and you'll be made aware of the openings....
March 14, 2011 at 11:20 pm
Agree, tested SELECT * FROM sys.dm_os_cluster_nodes
...
March 14, 2011 at 11:15 pm
Ahh, excellent thanx Gail, I learnt something as well from this question.
Great stuff!
March 14, 2011 at 4:00 am
try the following:
select LEN(string2),len(RTRIM(LTRIM(string2))) from yourtablename
and compare the length it records.
March 14, 2011 at 3:46 am
Not to be rude, but you are asking us to teach you everything there is to know about SQL Server, A-Z.....
How about enrolling in a course to get you started?...
March 14, 2011 at 2:11 am
Even if someone has exactly the same size db's as you, your IO's may be way different than theirs, and would be a terrible baseline to follow.
You will have...
March 14, 2011 at 1:42 am
Sorry but you provided less information than needed to be able to provide an answer....
Have a look at: http://www.sql-server-performance.com/articles/per/hardware_planning_p1.aspx
You'll quickly see this is not a straight forward answer...
March 14, 2011 at 12:58 am
what result do you get from:
SELECT top 1 SalesOrderID from yourtable
ORDER by SalesOrderID DESC
??
March 14, 2011 at 12:52 am
udpate emp_table set salary=50000 (here I failed to give condition, obviously all record will be updated)
Here I want to rollback my step 2, and I need my original value.
without a...
March 14, 2011 at 12:46 am
We host a few 64GB RAM systems (clusters - Physical), but I know some Banks in South Africa run even more...
The standard on the virtual machines are usually 32GB which...
March 10, 2011 at 9:21 pm
Viewing 15 posts - 526 through 540 (of 1,081 total)