Comments
Sort by recent activity
Not to plug the opposition (Not really) :roll:
Have you looked at CodeSmith (www.CodeSmthTools.Com) , you can set up extremely comprehensive templates that generate CRUD and lots of other code . There samples show you how, even to using full blown ORM's like NHibernate . Along with their own PLINQO ones
You can also Use T4 in VS to generate stuff , but it takes a bit more effort.
ALSO again there are INSERT DELETE and UPDATE templates in Sql Management Studio
Cheers
Mike / comments
Not to plug the opposition (Not really) :roll:
Have you looked at CodeSmith (www.CodeSmthTools.Com) , you can set up extremely comprehensive templates that generate CRUD and lots of other code ....
Thanks James
I have passed this to CodeSmith , it also explains why the Red Gate Event log contains so much stuff
They believe they have found an issue which they have fixed
Sorry to bother you
Mike / comments
Thanks James
I have passed this to CodeSmith , it also explains why the Red Gate Event log contains so much stuff
They believe they have found an issue which they have fixed
Sorry to bother you
Mike
PS
It seems to work normally if
CREATE TABLE #Test
(
Id INT ,
TestName VARCHAR(50)
)
SELECT
Id ,
TestName
FROM
#Test AS t
Mike / comments
PS
It seems to work normally if
CREATE TABLE #Test
(
Id INT ,
TestName VARCHAR(50)
)
SELECT
Id ,
TestName
FROM
#Test AS t
Mike
Hi Luke
Thanks for the response
The sort of thing I was thinking about was the sort of Intellesence improvements seeon in products like Re Sharper and Visual Assist X.
The candidate list is filtered not only based on full names say LotBaseLog in my example , but on "CamelHumps" id LBL would immediately suggest LotBaseLog or any other object that matched the LBL pattern in its Capitalisations . In essense the reverse of auto aliasing as present in SQLPrompt already
Cheers
Mike / comments
Hi Luke
Thanks for the response
The sort of thing I was thinking about was the sort of Intellesence improvements seeon in products like Re Sharper and Visual Assist X.
The candidate list is filtere...
Hi
Any Red Gate comment ?
Mike / comments
Hi
Any Red Gate comment ?
Mike
Hi
any thoughts on this one , I really do want to play with SQL Search
Mike / comments
Hi
any thoughts on this one , I really do want to play with SQL Search
Mike
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
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 ...
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
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 ...
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
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...
PS just an aside the $CURSOR$ is case sensitive
This was posted ages back
Mike / comments
PS just an aside the $CURSOR$ is case sensitive
This was posted ages back
Mike