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...
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,...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
May 12, 2010 at 5:42 pm
Viewing 15 posts - 451 through 465 (of 492 total)