Viewing 15 posts - 1,786 through 1,800 (of 18,926 total)
Steve Jones - SSC Editor (10/21/2011)
The three inserts in the second table should have PKs of...
October 21, 2011 at 8:51 am
You can't put a tooltip on a report parameter. You can do that on a textbox and possibly other objects.
October 21, 2011 at 8:40 am
Ninja's_RGR'us (10/21/2011)
Please post the good & bad actual execution plan.
October 21, 2011 at 8:36 am
Please post the good & bad actual execution plan.
October 21, 2011 at 8:11 am
EricEyster (10/21/2011)
Only 1 SQL2000 server left2000 = 1
2005 = 5
2008 = 7
2008R2 = 4500
4500????????????????????????????????????????????????????????
October 21, 2011 at 6:49 am
Lavanyasri (10/21/2011)
HI ,How to find memory bottle neck [ extra RAM required ] using perfmon or any other way??
Start with Gails article. That was my next step if...
October 21, 2011 at 6:48 am
karthikeyan-444867 (10/21/2011)
how to know what is the default collating sequence assigned for any database?
SELECT
name
, database_id
, collation_name
, *
FROM
...
October 21, 2011 at 6:13 am
karthikeyan-444867 (10/21/2011)
ORDER BY LEFT(Name,1) COLLATE SQL_Latin1_General_CP1_CS_AS DESC, Name
I still don't understand the working mechanism of these queries.
COLLATE changes the collation, or the way sql handles text.
CS means case sensitive
AS means...
October 21, 2011 at 5:57 am
karthikeyan-444867 (10/21/2011)
order by LEFT(name,1), ASCII(name) desc
How it works internally?
Of the 2 solutions, I think this is the one that works for you (watch the extra columns to see what's...
October 21, 2011 at 5:56 am
GilaMonster (10/21/2011)
Index rebuilds are bulk operations. They are fully logged in full recovery (entire page images are logged), they can...
October 21, 2011 at 5:27 am
GilaMonster (10/4/2011)
Ninja's_RGR'us (10/4/2011)
~Dev~ (10/4/2011)
The rebuild operation can be minimally logged if the database recovery model is set to either bulk-logged or simple.Choosing a Recovery Model for Index Operations:
Actually makes no...
October 21, 2011 at 5:10 am
Looks like you are really green at this.
The best thing you can do right now is buy a book or find online tutorials and start playing with it....
October 21, 2011 at 4:44 am
derekr 43208 (10/20/2011)
CoolThanks
Have you had a run at the Denali CTP?
Not really. I can confirm that the ctp 3 release correctly installs in vista. You can still run...
October 21, 2011 at 4:40 am
Viewing 15 posts - 1,786 through 1,800 (of 18,926 total)