Viewing 15 posts - 8,911 through 8,925 (of 9,641 total)
antonio.collins (4/1/2008)
if you added an indexed identity column to the table, using ident_col % N = 0 will not use the index and you'd still be table scanning but at...
April 1, 2008 at 7:23 pm
I don't if it will reduce the size used of the plan in cache, I would guess not as it will build the same plan for the query, but I...
April 1, 2008 at 9:10 am
Usecounts tells you how many times a plan has been used since the last SQL Server restart. YOu can find out the sql executed by using this query:
Select *...
April 1, 2008 at 8:12 am
Ashwin,
Your example queries are definitely different and will have different plans. The IN operator is basically a shortcut for writing where column1 = x OR column1 = y OR...
April 1, 2008 at 7:24 am
GSquared (3/31/2008)
Jack Corbett (3/29/2008)
You obviously do not have autoshrink enabled so you need to manually shrink your transaction log using DBCC ShrinkDB or DBCC ShrinkFile
Don't use autoshrink. It's a...
March 31, 2008 at 10:56 am
chinni (3/31/2008)
if we use left join we display all records in left table.......but we need to display only new record.........
That is where the Where U.key_fields is null comes in, U.key_fields...
March 31, 2008 at 10:19 am
Cory Ellingson (3/31/2008)
March 31, 2008 at 10:16 am
Wayne,
You don't mention which version of VB is being used, but if it is the latest bersion of VB.NET don't let them read anything about Linq until you get them...
March 31, 2008 at 8:09 am
Thanks for the nice words Jeff. I just try to be realistic.
March 31, 2008 at 7:23 am
Cory,
Certainly having a degree won't hurt you, but I know several very good programmers and SQL Server people who do not have a Bachelor's, but an associated from a...
March 30, 2008 at 11:26 am
I have nothing against getting a degree, but, as Jeff said, I am not sure what you gain on top of your experience. Do you feel green because the...
March 30, 2008 at 6:29 am
Jeff Moden (3/29/2008)
March 29, 2008 at 6:26 pm
There is not an option in SSMS, but earlier this week I saw a tool on a blog that enabled what you are looking for. Unfortunately I did not...
March 29, 2008 at 5:42 pm
No you cannot program an event in RS.
March 29, 2008 at 5:22 pm
If you are running against a named instance check out this link:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2776768&SiteID=1
You should also check this link:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=739396&SiteID=1
March 29, 2008 at 5:13 pm
Viewing 15 posts - 8,911 through 8,925 (of 9,641 total)