Viewing 15 posts - 61 through 75 (of 325 total)
L' Eomot Inversé (3/10/2013)
Nice question and good explanation. Thanks Ron.
+1
I marked it too soon 😉
too soon to be correct 😛
March 10, 2013 at 10:48 pm
swapnil.bole (3/8/2013)
Hi demonfox,Actually i am new in sql, so could you please tell me What i have to do exactly?
I suggest you go through some of the performance articles ,...
March 8, 2013 at 4:57 am
if you see in the executipn plan .. the estimated no. of rows are around 3600 whereas actual rows are around 100,000 .. that's a huge difference.. try updating the...
March 8, 2013 at 2:11 am
swapnil.bole (3/8/2013)
@SSC Eights!
Table defination is:
CREATE TABLE TABLE1
(
intIdintNOT NULL,
bintTimeStampbigintNOT NULL,
...
March 8, 2013 at 1:44 am
winmansoft (3/8/2013)
demonfox (3/7/2013)
You can't .. that's how SQL Server stores it .. check it out on this link
http://msdn.microsoft.com/en-us/library/ms179882.aspx
..
I found this in your link
It is important to remember that while...
March 8, 2013 at 1:36 am
swapnil.bole (3/8/2013)
I have table contains millions of records.
When i fired query to get record by id. Query get millions of rows for that it take 2-3 second time.
How can...
March 8, 2013 at 12:12 am
syscomments is there for backward compatibility only.
Use sys.sql_modules in SQL 2005 and newer. The definition column contains the T-SQL code for the module.
here is the code to find...
March 7, 2013 at 11:47 pm
ntreelevel (3/7/2013)
I need to modify the SP so that it selects one more column called supervisor.
The code to get the...
March 7, 2013 at 11:41 pm
winmansoft (3/7/2013)
I heard we can insert currency Symbols like $ to Money and small money datatypes. But while i am trying i realized we can insert $ into money datatype...
March 7, 2013 at 11:34 pm
winmansoft (3/7/2013)
Lynn Pettis (3/6/2013)
Does this get you started?
with TopDates as (
select top (100)
MyDates
from
dbo.MyTable
order by
MyDates desc
)
select min(MyDates) from TopDates;
That...
March 7, 2013 at 11:20 pm
vinu512 (3/7/2013)
March 7, 2013 at 10:37 pm
The first three items are required for subqueries. There are only 32 nesting levels allowed and if a TOP clause is used, an ORDER BY must be included.
actually, It's otehr...
March 7, 2013 at 8:59 pm
nice and easy for the last day of the week ..
thanks for the question !!!
March 7, 2013 at 8:57 pm
Lokesh Vij (3/7/2013)
Actually the confusion was this statement
"every create store procedure and create function, always contains...
March 7, 2013 at 12:58 am
the explanations says
The CREATE PROCEDURE statement cannot be combined with other Transact-SQL statements in a single batch. The same rule applies to Functions as well, but this is not noted...
March 6, 2013 at 11:39 pm
Viewing 15 posts - 61 through 75 (of 325 total)