Viewing 15 posts - 451 through 465 (of 492 total)
Krasavita (5/18/2010)
It happend yesterday, how long trace would keep what happend in past?
The default trace is limited to 20MB, but the last 5 trace files are kept. Hopefully there...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 18, 2010 at 5:04 pm
If your application fails because of a SQL Error you need to fix the app. There should be (almost) no unhandled errors within the app, related to its SQL interaction,...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 17, 2010 at 10:37 pm
You should know at least enough to install and configure these so they work, even on a cluster environmnet. Then you should be able to do basic things like export,...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 17, 2010 at 9:23 pm
It also depends on what the users are doing. Is it possible for them to use SQL Express? It's free!
If it's just an app connecting to a database and...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 17, 2010 at 9:12 pm
You need to run these two queries which will give you an idea of hat data is corrupt. The records are there, it just looks like a type value has...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 17, 2010 at 8:08 pm
dlink (5/17/2010)
Is it possible to query from a global temp table from another server via linked server?When I use
SELECT * from linked_server.db.owner.##GlobalTemp
I get a message:
Invalid object name ##GlobalTemp
Since the ##GlobalTemp...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 17, 2010 at 5:40 pm
Henry Treftz (5/17/2010)
I want the query to fail and the connection to remain
Why? Is this an application? In general unless you have built in functionality to do this, like a...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 17, 2010 at 5:34 pm
Or worse still, they didn't know what they were doing and created all the PKs as non-clustered and then created clustered indexes.
I go with Jason, drop and re-create the PKs...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 17, 2010 at 5:27 pm
Not sure what advise you are looking for. Except I saw the samproblem about a year ago when our system admins decided to apply an SP to Windows XP. All...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 17, 2010 at 5:21 pm
It's been a while since I've done this, so I don't know all the details, but it is theoretically possible to create a new empty log file and get the...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 16, 2010 at 10:36 pm
What are you seeing in PerfMon?
SQL is memory hungry, SQL 2005 Standard Edition's memory usage is only limited by the OS.
On 64 bit servers if you are on SP3 and...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 13, 2010 at 9:54 pm
.. creating indices would generally help select statements. But in this case as it is a update, would it have any negative impact ? ..
Only if you are also updating...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 12, 2010 at 10:39 pm
How are you viewing the characters via Managment Studio?
Is this a straight query as in select * from...
What about the local server or workstation environment settings, are these always the...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 12, 2010 at 9:56 pm
Yes, creating a non-clusterd index on the two columns would help, you probably want to do it after hours as it's going to take some time and cause blocking. Unless...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 12, 2010 at 8:47 pm
Also where in the index are these 2 columns? If they aren't the first 2 columns you are doing a table or clustered index SCAN, of 8 million rows.
Send us...
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 12, 2010 at 5:42 pm
Viewing 15 posts - 451 through 465 (of 492 total)