i have recently had the need to search the every database on the server for a particular string.
i came up with this... it has lots of room for improvement but it works
2009-08-03 (first published: 2008-11-11)
969 reads
This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for 🙂
2008-10-10
1,009 reads
I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. I am using a cursor in some cases but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alternative?
2008-03-20
6,666 reads
How you use dynamic SQL, when you should - and when you should not.
2008-03-18
6,537 reads
@PartId should probably be declared as an Int and not a VarChar@PartId is not initialzed and therefore is null before the select:If the select returns 0 rows then the @PartId will be unchanged and will remain null.If the select does contain rows and the all values for Part_ID are null then @PartId will be assigned null.After […]
2005-05-26
And many things in file-based systems, like definite record numbers, simply do not exist in SQL server (and for good reason - it's a set of data. If you want it ordered, use an order by).Also... many of the systems like Fox/Access use cursors a great deal - server side cursors are usually the substitute […]
2005-05-24
"The customer lists all the features they want in priority order."And how often can your customers tell you exactly what they want, let alone as a prioritized list?If you are lucky enough to get a feature list, and it doesn't change half-way through, everything will be top priority. If you make the decision for them, […]
2005-05-18
Good article reference, Frank (and congrats again on the MVP!) I did not know about precedence of when the WHERE clause gets evaluated between the two forms.This begs a question of me, though. I recently wrote the following code:select distinct fieldlist blahblahblah.... from EntityHistory en join enLookupCodes lc1 --get state on ad1.refstateid = lc1.id join enEntityAddressTypes […]
2005-04-22
It depends on your server hardware. Just kidding , but hardware an RAM definitely has an impact. Dont' know if this helps you or not, but I have a 16.5 Gig user DB on a 2 X 2.4 gig CPU server with 2 gigs of RAM and DBCC CheckDB's complete on this in about 7 1/2 […]
2005-04-20
2005-04-20
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers