Viewing 15 posts - 45,886 through 45,900 (of 49,552 total)
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2008 at 8:12 am
Do you just want the last 2 characters? If so...
SELECT @T = RIGHT('Te6st03',2)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2008 at 7:38 am
Was that while (Select * from Table2) was running?
Is the time taken by the query consistent?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2008 at 7:37 am
Use the sys.master_files view to get a list of all the files of all the databases known to SQL. It does contain the sizes of the files.
Is that what you're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2008 at 7:27 am
Is there anything useful in the SQL Error log?
Do you have a backup from before this started?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2008 at 7:16 am
ngarg (7/7/2008)
Expect_date of found table row.
Which row?
What I'm looking for is the required output so that if I write a query for you, I can test it and tell if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2008 at 4:06 am
Is there any blocking? If you check in sysprocesses while the query of the second table is running, do you see anything listed for LastWaitType? If so, what?
how long does...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2008 at 4:03 am
Viewing 15 posts - 45,886 through 45,900 (of 49,552 total)