Viewing 15 posts - 106 through 120 (of 716 total)
Nakul Vachhrajani (4/5/2011)
If the clustered index is not created with the UNIQUE property, the Database Engine automatically adds a 4-byte uniqueifier column to the table. When...
April 6, 2011 at 9:36 am
CirquedeSQLeil (4/5/2011)
UMG Developer (4/5/2011)
How many people actually use the ODBC date literals?I think very few in comparison.
Yeah, I think the number of people answering correctly shows that. (Currently 33% of...
April 5, 2011 at 11:06 pm
By default SQL Server uses everything that is available that it needs, if the OS pushes back SQL Server can give some back. (It is normally a good idea to...
April 5, 2011 at 11:03 pm
That should work and give accurate results. If you think it isn't can you provide the DDL and sample data so that we can see what you are seeing.
Note: That...
April 5, 2011 at 10:57 pm
If what Wayne produced is what you want, I might simplify his code just a little:
DECLARE @test-2 TABLE (MyTime VARCHAR(4));
INSERT INTO @test-2
VALUES ('1425'),
...
April 5, 2011 at 9:16 pm
tooba111 (4/5/2011)
Here is my question I have source data like thisColumn_Name(Time)
1425
945
1258
And target field is Time
How I can change Military time to normal time
Time
2:25 AM
9:45 PM
12:58 AM
Thanks in advance.
It...
April 5, 2011 at 9:07 pm
Nice question, thanks!
How many people actually use the ODBC date literals?
April 5, 2011 at 8:55 pm
I'm not sure I would do it this way, but with mixed types you have challenges.
Try this:
Select case when PatIndex('%[^0-9]%',left(Table2.[DESC], 6)) = 0 then
CONVERT(DATETIME, CAST(Table1.YEAR * 10000...
April 5, 2011 at 5:53 pm
Jeff Moden (4/5/2011)
forsqlserver (4/4/2011)
Looping Myself...Please explain.
My guess is they are used to being added for immediate notifications when replying to a thread, so they added a reply to get notifications....
April 5, 2011 at 2:57 pm
GilaMonster (4/5/2011)
Look at the time of the log entry. Look at the time the message gives.
Guess I should read the whole message. 😉 I was assuming that it ran...
April 5, 2011 at 11:03 am
GilaMonster (4/4/2011)
UMG Developer (4/4/2011)
I assume they are part of the CHECKDB process that runs when SQL Server starts.CheckDB doesn't run when SQL starts.
Gila,
Then what are all of these log entries...
April 5, 2011 at 9:44 am
Please note that some other things can be broken by renaming the SA account. I have seen a number of people with failed SQL Server upgrades because of that. (Yes...
April 4, 2011 at 11:09 pm
Jeff Moden (4/4/2011)
April 4, 2011 at 11:05 pm
CELKO (4/4/2011)
April 4, 2011 at 11:03 pm
Brian Kukowski (4/4/2011)
April 4, 2011 at 10:19 pm
Viewing 15 posts - 106 through 120 (of 716 total)