How can we help you today? How can we help you today?
MikeONeill
Activity overview Badges (0) Posts (58) Comments (66)

Comments

Sort by recent activity
Hi Any Red Gate comment ? Mike / comments
  1. Community
  2. SQL Prompt 5 EAP
  3. Shortcuts
Hi Any Red Gate comment ? Mike
0 votes
Hi any thoughts on this one , I really do want to play with SQL Search Mike / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Management Studio Sluggish
Hi any thoughts on this one , I really do want to play with SQL Search Mike
0 votes
This is typical , I have a server with 3 "big" db , normally 8-10 gb This is the sount of sys.objetcs VIEW 68 SQL_TABLE_VALUED_FUNCTION 29 SQL_STORED_PROCEDURE 1770 362 FOREIGN_KEY_CONSTRAINT 142 USER_TABLE 293 313 SQL_SCALAR_FUNCTION 127 PRIMARY_KEY_CONSTRAINT 258 263 SQL_TRIGGER 19 1 of the 2 biggest . It the LH column I was seeing the performance hit most Some of the Sp's are quite lengthy , often 300 lines + for driving reports etc , but there is a mix of small & large I think for confidentiality I can't attach schemas I hope this helps Mike / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Management Studio Sluggish
This is typical , I have a server with 3 "big" db , normally 8-10 gb This is the sount of sys.objetcs VIEW 68 SQL_TABLE_VALUED_FUNCTION 29 SQL_STORED_PROCEDURE 1770 ...
0 votes
Hi I think I have cracked it ... My works lap top was rebuilt so I installed 2008 first time as a clean install. I also installed SQL Prompt , Refactor and Search as it was before . I hit the slow response , so I uninstalled 2008 reverted to 2005 as it was previously before the rebuild, plus the 3 add ins BUT no improvement , still type and wait 2-3 sec for the typing to show. I now disabled SQL Prompt -- no joy I uninstalled SQL Search and Voila ,all back to normal in 2005 I have now upgraded to 2008 and all is still well , so I hate to say it but it would seem that SQL Search was the culprit . I do not have intalled and all is fine. As an side I have all 3 add ins installed in 2008 on my other lap top with Win 7 and 4Gb Ram and do not see it , but the db sizes on my works Lap Top , the one that was suffering are much bigger. Can SQL Search be affected by Db size even when its nominally "doing nothing" It certainly looked like the sort of Parsing clashes I have seen with VS2008 addins trying to parse the same file at the same time. Hope this helps, please can you pass on to the SQL Search team for comment Mike / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. SQL Management Studio Sluggish
Hi I think I have cracked it ... My works lap top was rebuilt so I installed 2008 first time as a clean install. I also installed SQL Prompt , Refactor and Search as it was before . I hit the slow ...
0 votes
I posted a similar request fro using Camel case shortcuts eg BatchValueView would be accessed by <bvv> , as you see in Visual Assist X etc ie filtering on the Camel Case capitals Looks like 2 votes Mike / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. search using partial table names
I posted a similar request fro using Camel case shortcuts eg BatchValueView would be accessed by <bvv> , as you see in Visual Assist X etc ie filtering on the Camel Case capitals Looks like 2 votes...
0 votes
PS just an aside the $CURSOR$ is case sensitive This was posted ages back Mike / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Control final position of cursor in Snippet Manager
PS just an aside the $CURSOR$ is case sensitive This was posted ages back Mike
0 votes
Total activity
174
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
50