Viewing 15 posts - 44,971 through 44,985 (of 49,552 total)
bhuvnesh.dogra (8/17/2008)
Now can i expect an answer from ..............experts......???
What are you looking for? There was a good explanation in the newsletter for 14th Aug and there's a discussion in...
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
August 18, 2008 at 1:42 am
Or
select * from #Like_Test
where Col1 Like '%Cu/_%' ESCAPE '/'
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
August 18, 2008 at 1:41 am
Odd.
The only thing I can think of is perhaps the CD is slightly damaged and the one drive is just better at reading through the damage than the other.
Try copying...
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
August 17, 2008 at 2:12 pm
marjanagha (8/17/2008)
So, it's very puzzling that the cd works on the desktop but not on my laptop.
Same OS? Is one perhaps a 32 bit OS and the other a 64?
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
August 17, 2008 at 8:43 am
Where did you get the installation files from? It may be worth trying to get another copy and install from that. Sounds like one of the files is corrupt.
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
August 17, 2008 at 7:00 am
If I understand you correctly, you're looking for some way to prevent anyone from reading your database from a tool like management studio?
If so, it can't be done. If 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
August 17, 2008 at 6:55 am
Odd. I suspected it was a problem with the file's max_size setting, but apparently not.
Grasping at straws here... what's the command that you're using to shrink the file?
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
August 17, 2008 at 3:22 am
SQL 2000-related questions should rather be posted in the SQL 2000 forums in future please.
FirstTable has 1 lakh record , Second table has 2 Lakh record and Third and...
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
August 17, 2008 at 3:10 am
The two instances should be listed separately under the Process object. Identifying which is which is a little more tricky
As well as the memory counters, add the counter "ID Process"...
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
August 17, 2008 at 2:57 am
Joe Torre (8/16/2008)
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
August 16, 2008 at 3:55 pm
You can.
What would probably be best is to make the entire thing handle an number of rows (set-based processing instead of row by row) and then use a cursor...
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
August 16, 2008 at 4:19 am
We get tax rebates. Not sure of the full details. I don't do the tax myself and the tax consultant I have knows what to claim and how.
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
August 16, 2008 at 3:14 am
There's the cause of the bad plan straight off. For the optimiser, doing a RID lookup of 45 rows in a table with more than 300000 is very cheap and...
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
August 15, 2008 at 3:21 pm
David Branscome (8/15/2008)
Shrink file has the advantage of reducing the size of the database and reducing the amount of disk that has to be covered to query a table's data.
And...
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
August 15, 2008 at 3:20 pm
Interesting discussion.
For the last 4 years I've worked for a company (or more accurately for a manager) that was more than generous about training. I was allowed to buy any...
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
August 15, 2008 at 2:29 pm
Viewing 15 posts - 44,971 through 44,985 (of 49,552 total)