Viewing 15 posts - 496 through 510 (of 1,478 total)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 7, 2010 at 3:35 am
What is the type of the column TimeStarted? Is it a string or datetime?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 7, 2010 at 3:29 am
Viewing 15 posts - 496 through 510 (of 1,478 total)