Viewing 15 posts - 496 through 510 (of 1,479 total)
You don’t need to give name for the join of the derived table. Bellow you can see a version that gets compiled. I think that you should...
January 30, 2011 at 8:54 am
From security point of view if you use a query that references the table, the user must have permissions directly on the tables, but if you use a view and...
January 23, 2011 at 4:05 pm
There is a good chance that I’m missing something here, but if you want to get rid of the sort, why did you add a sort clause to your query?
Adi
January 18, 2011 at 4:01 am
I don’t know why on one server you have an error and on other server you don’t. Maybe you have different service packs on both servers. In any...
January 18, 2011 at 3:52 am
I couldn’t find an error like that in SQL Server 2005. Are you sure that you are using SQL Server 2005 and not a different edition (for example sql...
January 18, 2011 at 3:02 am
Here is one way of doing it. Maybe there is also a nice way of doing it using recursive CTE:-)
create table TimeTable (dt datetime)
insert into TimeTable (dt) values ('20000101')
declare...
January 12, 2011 at 2:37 am
In Asp.net Cyrillic is one of the languages that require database collation and application layer text encoding to avoid character conversion issues. So the user needs to either use...
January 10, 2011 at 9:23 am
Also this
select tbl.col.value(('.[1]'),'varchar(10)')
from @xml.nodes('/Root/SubNode/*') tbl (col)
Very nice. Learned something new today:-)
Adi
January 10, 2011 at 6:26 am
I have to admit that I have no idea why it works for you on one procedure and it doesn’t work on a second procedure, but I think that in...
January 10, 2011 at 6:23 am
Since you use different tags, I think that you can do it only with union all query. If you can modify the XML so the tag’s name will be...
January 10, 2011 at 6:14 am
In the past I needed to decrypt procedures that were written with SQL Server 2000 and SQL Server 2005. I had to invest few minutes to look for a...
January 10, 2011 at 6:04 am
I selected the first option (“It runs perfectly as you would expect”). The correct answer was – “It runs perfectly but you would expect it to fail”. Apparently...
January 10, 2011 at 5:33 am
According to BOL a lock takes approximately 100 bytes of memory, so I guess that you can check who much locks were used and get estimation about the memory usage....
January 5, 2011 at 8:29 am
You’ll have to disable one of the constraints in order to insert the first record (alter it using the NOCHECK key word). After you’ll insert the matching record into...
December 26, 2010 at 7:16 am
Are you sure that it caused deadlock? Could it be that it causes massive blocking but not deadlock? Can you let us know how you came into conclusion...
December 7, 2010 at 3:35 am
Viewing 15 posts - 496 through 510 (of 1,479 total)