Viewing 15 posts - 1,531 through 1,545 (of 7,504 total)
Did you try indexing your table for the columns in your query ?
As you are talking performance, with your current design, this query (and almost all queries for that matter)...
December 15, 2011 at 10:01 am
I would implement windows security for that purpose whenever I can.
( both for your usage as sqladmin as well as for the other person to use in that monitoring tool/service...
December 15, 2011 at 9:52 am
if you are counting using e.g;
select count(*) from yourtable with (nolock)
Only in this case you'll get a good approx.
(because the number doesn't have to be exact)
December 15, 2011 at 9:47 am
SQLKnowItAll (12/15/2011)
..."Have you tried turning it on and off again?" -IT Crowd..
Darned, I loved that series.
You've just made my day even better. #Goodtimes
December 15, 2011 at 9:39 am
December 15, 2011 at 7:46 am
Grant Fritchey (12/15/2011)
in my opinion,is genuine people are working with their 100% own knowledge base?, they are also using google and other sources right?
100%, no one does that. Not even...
December 15, 2011 at 5:25 am
sqldba2k8 (12/14/2011)
1)make coffee. There is no checklist to do because I have all I need on my smart phone
2)sqlperformance issues and a couple of server crashes
3)Do you want the scripts...
December 15, 2011 at 12:22 am
to ease your load, you could consider creating FK-constraints after the load has been performed.
But keep in mind to put them back in place.
December 14, 2011 at 1:36 am
Did you refresh the ssms object browser ?
Can you post the DDL for the used :
- create database
- the concerned table ( and indexes )
December 13, 2011 at 6:14 am
How about using the oFile.DateCreated property to determine the age of your bak file ?
December 13, 2011 at 6:10 am
Just today I've seen a tweet pointing to a delegation troubleshooting blog:
December 13, 2011 at 12:00 am
We choose to leave one SQL2000 instance to host DTS-packages until the project teams get budget to upgrade the packages to SSIS.
Main reason is to avoid troubles as you have.
We...
December 12, 2011 at 10:47 am
- at db upgrade time. (after restore, together with all other db maintenance)
we have auto update stats enabled.
We check every now and then how old statistics are and rebuild them...
December 12, 2011 at 9:57 am
Jeff Moden (12/12/2011)
ALZDBA (12/11/2011)
As a firefighter sysadmin/dba, I cannot but embrace your choice of solution.
( insert in table a server a with a trigger to insert into serverb some table)
This...
December 12, 2011 at 6:19 am
R.P.Rozema provided the solution.
I just want to point to Some common date routines by Lynn Pettis
and
my rules of thumb for date/datetime related stuff http://www.sqlservercentral.com/Forums/FindPost1219915.aspx
December 12, 2011 at 2:05 am
Viewing 15 posts - 1,531 through 1,545 (of 7,504 total)