Viewing 15 posts - 6,811 through 6,825 (of 8,416 total)
Is it too late to add this to the mix...?
;WITH
TypeConvert AS
(
-- Convert to sql_variant for the upcoming...
October 28, 2009 at 3:42 pm
Kristy Lanter (10/27/2009)
October 27, 2009 at 3:25 pm
Kristy Lanter (10/27/2009)
How about Enterprise edition 64 bit?
Enterprise Edition has always had the ability to lock pages in memory.
October 27, 2009 at 2:53 pm
Yes I would think so too - I just haven't been able to make it behave the way we would expect yet.
It's currently sat in my interesting-but-useless pile. The...
October 26, 2009 at 5:12 pm
Good luck, and you're welcome of course.
edit: posting that, it's just occurred to me to ask you to check that your code doesn't switch context away from the target database...
October 26, 2009 at 8:23 am
I do agree with Mr Guru there about the ORDER BY thing, but as a matter of curiosity, I think the following also guarantees a repeatable order:
WITH TS AS (SELECT...
October 26, 2009 at 8:22 am
Interesting - and no, ALTER DATABASE is not allowed within a transaction.
Are you sure you're not just encountering an error of some kind between the SINGLE_USER and MULTI_USER changes?
An error...
October 26, 2009 at 7:58 am
Ok, but in which database is the stored procedure defined? AttendaDW? My guess would be not ;c)
The stored procedure needs to running in the context of the database...
October 26, 2009 at 7:27 am
Activity Monitor connections are a favourite.
If you need exclusive access to a database (for some reason...?) the traditional approach is to change context to that database (with the USE [database_name]...
October 26, 2009 at 4:23 am
Andrew Gothard-467944 (10/26/2009)
50 Characters? That's not a column name, that's an essay!
Apparently, in the next release, all data will be stored compressed in the column names - there won't...
October 26, 2009 at 3:51 am
ranjitrjha (10/22/2009)
Your explanation makes sense but when i am running
select top 10 * from table1
select top 10 * from table1
then for both queries, result set is same.
It's only when I...
October 26, 2009 at 1:31 am
I've come across what I believe to be both ends of the spectrum on this one.
First up, an old application built to be compatible with any back-end database (restrain yourself...
October 26, 2009 at 12:57 am
coboljobs2003 (10/20/2009)
(This webservice which is...
October 26, 2009 at 12:43 am
Alvin Ramard (10/21/2009)
Bob Hovious 24601 (10/21/2009)
Sigh... I always over-design things.
Before the XML data type, all data could be stored in tables with a no more than 4 columns. Now...
October 21, 2009 at 5:17 pm
Bob Hovious 24601 (10/21/2009)
Emperor Paulpatine,XML makes db design much simpler too:
create table XMLTable (ID bigint, Data xml)
...what's the ID column for? :laugh:
October 21, 2009 at 3:55 pm
Viewing 15 posts - 6,811 through 6,825 (of 8,416 total)