Viewing 15 posts - 106 through 120 (of 219 total)
Grant Fritchey (5/28/2010)
I would argue that while all three compile and run, none of them is "correct."
What do you think about the syntax of the following statements?
SELECT column1 * column2...
June 1, 2010 at 8:19 am
ziangij (5/28/2010)
However was wondering, when SSMS executes the query, it would have to do some effort to remove spaces between the words 🙂
SSMS itself does not execute queries because it...
May 28, 2010 at 4:36 am
webrunner (5/27/2010)
May 27, 2010 at 8:45 am
Hugo Kornelis (5/27/2010)
Note that IMPLICIT_TRANSACTION OFF is the default; vk-kirov could have omitted this and mentioned "default settings" in the text for the same effect.
When I was writing the question,...
May 27, 2010 at 3:46 am
Paul White NZ (5/26/2010)
The same is true for geometry and geography
On reflection, I think I prefer lower case for these method calls. What do you think?
I like to upper-case...
May 26, 2010 at 12:56 pm
Tom Garth (5/26/2010)
The actual number of rows in #t with a default installation is 20449.
It depends 😀 I've got 3969 rows with my default installation.
May 26, 2010 at 12:20 pm
Paul White NZ (5/26/2010)
For me, DECLARE @b-2 sYsNaMe; works just fine in a case-sensitive collation (SQL Server 10.0.2775 Dev x86).
Hmmm... Microsoft changed it in SQL Server 2008. In...
May 26, 2010 at 12:11 pm
Paul White NZ (3/30/2010)
It seems odd to me that type names must be lower cased in a case-sensitive database.
It's not true (or I don't understand what you mean). The names...
May 26, 2010 at 6:27 am
honza.mf (5/25/2010)
If someone discover another collation in another language with similar behaviour, I will be very glad to have such information.
Here is a script which finds that collations (you should...
May 25, 2010 at 1:41 am
Very nice question, I learned something new.
honza.mf
On SQL Server with CZECH_CI_AS collation returns 3 rows ('CH', 'Ch', and 'ch') - this collation is case insensitive.
Note that CZECH_CS_AS (case sensitive...
May 25, 2010 at 1:14 am
Paul White NZ (5/24/2010)
Might be the same issue as http://internalsviewer.codeplex.com/WorkItem/View.aspx?WorkItemId=5882. Make sure you download the correct version - for either SSMS 2005 or 2008.Download choice page:http://internalsviewer.codeplex.com/releases/view/21139
Thanks, this helped.
Nice plug-in....
May 24, 2010 at 1:59 pm
Paul White NZ (5/24/2010)
Some people find Internals Viewer (an SSMS plug-in) easier for some tasks:
Oh no... I knew it 🙂
The Add-in 'InternalsViewer.SSMSAddIn.Connect' failed to load or caused an exception.
...
Error Message:...
May 24, 2010 at 12:54 pm
Paul White NZ (5/24/2010)
EXTENTINFO, IND, and PAGE.You also need TRACEON(3604) with PAGE of course.
Thanks for the information. I definitely need to play with these commands for better understanding of table...
May 24, 2010 at 11:52 am
Paul White NZ (5/24/2010)
All three can be examined in detail using the familiar DBCC commands to verify that.
What is the list of these commands?
1) DBCC PAGE;
2) ... ?
May 24, 2010 at 8:49 am
WayneS (5/20/2010)
XML Secondary indexes have a B+-Tree index structure.XML Secondary Indexes: http://msdn.microsoft.com/en-us/library/bb522562.aspx
I couldn't find a reference to B+ trees on that BOL page.
Where can I read about secondary XML...
May 21, 2010 at 3:47 am
Viewing 15 posts - 106 through 120 (of 219 total)