Viewing 15 posts - 451 through 465 (of 488 total)
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
Service Broker is part of the answer, that's why you don't see any jobs. The other part is that it is essentially reading the logs and using that to determine...
May 12, 2010 at 2:51 pm
If you shrink the file you'll have to do the index maintenance regardless of you you do it, sorry. The real question is what are you trying to do.
If this...
May 10, 2010 at 5:38 pm
Mani-584606 (5/10/2010)
myserveramed instance
But the same is NOT working when I accessed through VPN. From VPN the below is working myserver\<named instance>,port.
What should I do...
May 10, 2010 at 2:23 pm
Viewing 15 posts - 451 through 465 (of 488 total)