Viewing 15 posts - 241 through 255 (of 3,221 total)
scarlam (10/25/2012)
How...
October 25, 2012 at 7:07 am
To assist those who want to assist you. please post the table definition, sample data and required results from the sample data.(Click on the first link in my signature block...
October 24, 2012 at 10:07 pm
If I understand your request correctly, this may be helpful to you
CREATE TABLE #Dob(birth VARCHAR(15))
INSERT INTO #Dob
SELECT '24-10-2012' UNION ALL
SELECT '01-01-2011'
...
October 24, 2012 at 7:29 am
Try reading these:
Estimating the Size of a Nonclustered Index
http://msdn.microsoft.com/en-us/library/ms190620(v=sql.100).aspx
Estimating the Size of a Clustered Index
http://msdn.microsoft.com/en-us/library/ms178085(v=sql.100).aspx
October 22, 2012 at 9:23 am
Here is one way;
-- Created only to show effect of ORDER BY clause
CREATE TABLE #t(proj VARCHAR(1),carac VARCHAR(5))
INSERT INTO #t
SELECT...
October 22, 2012 at 9:17 am
This might be what you need.
SELECT sqlserver_start_time FROM sys.dm_os_sys_info
Returns :
2012-10-17 23:03:26.687
So create your table and then insert the result of the T-SL, it will give you at least...
October 17, 2012 at 10:00 pm
Nice question - glad I read it 3 times .... subtle but nice
October 16, 2012 at 8:32 pm
Sqlism (10/15/2012)
Thanks for the reply ron,I am expecting a script, not thru GUI
Thanks again 🙂
In the previous link note the following:
You can also decide whether to save the package to...
October 15, 2012 at 7:05 pm
You can learn how by going to this link.
http://msdn.microsoft.com/en-us/library/ms141209(v=sql.100).aspx
October 15, 2012 at 6:24 pm
You can answer your questions by obtaining a copy of
Microsoft SQL Server 2008 Upgrade Advisor
http://www.microsoft.com/en-us/download/details.aspx?id=11455
October 15, 2012 at 6:48 am
scottichrosaviakosmos (10/14/2012)
October 14, 2012 at 3:35 pm
Thanks for a good question - good thing I had my coffee before answering
Again thanks
October 11, 2012 at 8:16 pm
Nice simple question on the basics. Every one should get this right (I hope)
October 10, 2012 at 9:01 pm
Viewing 15 posts - 241 through 255 (of 3,221 total)