Viewing 15 posts - 2,251 through 2,265 (of 2,894 total)
I would restart Server and repopulate the full-text catalogs. Have you done this?
Also, are you sure that this is one noise file used?
August 16, 2011 at 5:20 am
Phil Parkin (8/15/2011)
BUT, wait untill JC will see your post... [w00t] You will then know that your table is not a table [BigGrin]
Wow, Jesus monitors this forum too?
:hehe:
Joe Celko...
August 15, 2011 at 5:25 am
scottichrosaviakosmos (8/15/2011)
...I want it to make global. so that same time should be shown to all across world.
...
GETUTCDATE() is a function which returns date and time as UTC time (Coordinated...
August 15, 2011 at 5:16 am
Simple answer to your question is: NO - such aggregate function does not exist. There is a rationale behind it I guess. Such function would easely cause overflow.
You can try...
August 15, 2011 at 4:38 am
GETUTCDATE()
Is your friend. Then you can use localisation if required...
August 15, 2011 at 4:13 am
You can replace your:
set @nom=(select nom from dbo.mylogin1 where numtel=@numtel)
With
select @nom = nom from dbo.mylogin1 where numtel=@numtel
It will never fail again, however it will hide the fact that your...
August 15, 2011 at 4:11 am
If you allowed to link your servers you can use just insert query
August 15, 2011 at 4:06 am
Your question does look better now and your query looks fine to me.
If you post insert script for sample data you have we can see what it will return.
Meanwhile if...
August 11, 2011 at 8:52 am
SriSun (8/11/2011)
.. Is it a good practice to use composite primary key, rather I can create primary key on date_col and create nonclustered on idno....
1. It is a good practice...
August 11, 2011 at 8:38 am
Then you can tell your bosses to forget about it as in order to do it in SQLServer you will need to write your own tool yourself (c# or other)...
August 11, 2011 at 8:16 am
Could you please provide data insert script not an extract as it's useless.
You can follow the link at the bottom of my signature to find out how the question...
August 11, 2011 at 8:10 am
Why not to use simple old LEFT JOIN:
SELECT a.OneColumn
FROM TableA AS a
LEFT JOIN TableB AS b ON b.OneColumn = a.OneColumn
WHERE b.OneColumn IS NULL
I do assume that there are no rows...
August 11, 2011 at 7:52 am
Zeev Kazhdan (8/11/2011)
I was asked if SQL 2008 can obtain a data from Windows 2003 Event Viewer (especially
Application's Error Level), but from a quick browsing haven't seen any...
August 11, 2011 at 7:47 am
dave 92282 (8/11/2011)
August 11, 2011 at 7:34 am
Jayanth_Kurup (8/11/2011)
So it looks like when the querying objects without the schema name it actually preferred the sys schema object over the object created against the schema defined for this...
August 11, 2011 at 7:22 am
Viewing 15 posts - 2,251 through 2,265 (of 2,894 total)