Viewing 15 posts - 256 through 270 (of 2,436 total)
both work for me:
select cast (getdate() as smalldatetime)
select convert(smalldatetime,getdate())
select @@version
results:
-----------------------
2009-07-17 09:16:00
(1 row(s) affected)
-----------------------
2009-07-17 09:16:00
(1 row(s) affected)
------------------------------------------------
Microsoft SQL Server 2005 - 9.00.4207.00 (X64)
(1 row(s) affected)
July 17, 2009 at 8:16 am
... and yet another way to skin the cat ...
sp_MSforeachtable @command1="select count(*) as '?' from ?"
... granted not efficient, nor possibly accurate ...
July 17, 2009 at 8:06 am
No matter how large or small a software project is things can go well and on time.
Testing on a modular level can be quite elegant and efficient. Take Unix and...
July 15, 2009 at 1:08 pm
DBCC CHECKDB() --> this is executing in the default database which is probable master
That is why it is so quick. Whereas ...
DBCC CHECKDB(yous_database_name) --> is performing the DBCC on the...
July 15, 2009 at 8:45 am
Unless you are using an custom written application you will need to change (convert) all comp-3 (packed decimal) and comp (binary) data types to 'display' data on the mainframe first....
July 13, 2009 at 9:01 am
We use a software package called ECM - Enterprise Change Management - we have 250+ SQL Servers - it handles non-clustered SQL Servers but has issues wioth clusters !
Thats why...
July 10, 2009 at 7:36 am
hope this will help & make sense up to the extent that the information applies:
4GB RAM: /3GB (AWE support is not used)
8GB RAM: /3GB /PAE
16GB RAM: /3GB...
July 9, 2009 at 12:38 pm
Are you running 2000 Standard ot 2000 Enterprise ? If you are running SQL 2000 Standard then adding more memory to the server will not help since SQL 2000 Standard...
July 9, 2009 at 11:20 am
I have used many schemes for keyword usage in many programming languages over the last 27+ years. Maybe I am just getting lazy in my old age, all lower case...
July 8, 2009 at 9:25 am
You should be able to modify the password through the services msc beforehand. Do not restart any services until the password(s) have been changed via the services msc on all...
July 8, 2009 at 9:19 am
Very good question.
How does this behavior stack up against ACID though ?
July 7, 2009 at 7:46 am
hmmm ... I live kind of simply so I would like things to be special like my Sundays usually are dining-wise ...
breakfast - homemade biscuits and sausage gravy with think...
June 26, 2009 at 9:14 am
I agree with Jeff's first response ...
Been in that same situation and did almoist the exact same thing, just used a few more words ...
That manager was not long for...
June 15, 2009 at 10:54 am
Viewing 15 posts - 256 through 270 (of 2,436 total)