Viewing 15 posts - 45,901 through 45,915 (of 49,571 total)
This looks suspiciously like homework. Is that the case?
July 8, 2008 at 12:29 am
Advice? Sure. Don't go that route.
You're adding complexity to the system with dynamic SQL and you're potentially openings a sQL injection vulnerability Dynamic SQL will require that the user has...
July 8, 2008 at 12:17 am
How about you give us the entire requirement with several sample values and the results you want out?
July 8, 2008 at 12:03 am
Mani Singh (7/7/2008)
the SPID are system SPID's, so better be carefull is you are thinking of using the Kill statement.
The system spids are the ones reporting the deadlock, not the...
July 7, 2008 at 10:34 am
Wow, that's an impressive deadlock. Was that a once off, or is it reoccurring?
I would suggest that you enable either 1204 or 1222, not both. They have the same purpose,...
July 7, 2008 at 10:33 am
Steve Jones - Editor (7/7/2008)
I've often had some ID (identity/GUID) as the PK, but used a date for a clustered index since I often query on date ranges.
Likewise, but Ron...
July 7, 2008 at 10:25 am
No advantages I can see, and the disadvantage is that you are maintaining 2 indexes where you only really need to maintain 1.
Note, there are a few, very special, very...
July 7, 2008 at 10:24 am
Depends if you have synchronous or asynchronous mirroring.
In synchronous mirroring, the data is transferred to the mirror and confirmed as hardened in the mirror's transaction log before the client...
July 7, 2008 at 10:03 am
Can you also post the java code where you create and open the result set?
What's tha data type of rs? SQLServerResultSet?
Which line throws the error?
Is your linked list just a...
July 7, 2008 at 8:22 am
No need. The buffer pool is the majority of SQL's memory allocation. The remaining portion (often referred to as Mem To Leave) is by default 256 MB. You can change...
July 7, 2008 at 8:12 am
Do you just want the last 2 characters? If so...
SELECT @T = RIGHT('Te6st03',2)
July 7, 2008 at 7:59 am
Could you post the java code please? The SQL looks ok, but it would be useful to know what the java code is doing also.
July 7, 2008 at 7:58 am
Grinja (7/7/2008)
Profiler has not picked up any deadlocks.Yes some queries quick while others just time out or are incredibly slow.
Not asking about deadlocks. If you look in the sysprocesses table,...
July 7, 2008 at 7:44 am
It's for the buffer pool only.
Next time please post in an appropriate forum. Also, there's no need to bump after 30 minutes. It's a forum, not a chat room.
July 7, 2008 at 7:38 am
Was that while (Select * from Table2) was running?
Is the time taken by the query consistent?
July 7, 2008 at 7:37 am
Viewing 15 posts - 45,901 through 45,915 (of 49,571 total)