Viewing 15 posts - 46,936 through 46,950 (of 49,552 total)
If you only want the day (ie from 2008/04/10 you just want 10) then look at either the datepart function or the day function. Both will do wahat you want.
SELECT...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2008 at 4:26 am
Personally I don't see anything harsh in what he said. If the comment had been something like "You idiot, you're posting in the wrong #$%#$@ forum", then it would be...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2008 at 4:21 am
Your best bet will be to convert it to a stored proc and cahnge whatever's calling it.
How is that query being called? Front end app? Dynamic SQL?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2008 at 4:16 am
Robert (4/10/2008)
Many people work with both ss2k and ss2005, so a forum like this is not necessarily strict ss2005.
There's a SQL 2000 data corruption forum as well here. Posting...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2008 at 3:12 am
Should do. Just keep an eye on it for a while, make sure nothing else breaks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2008 at 3:04 am
Enterprise manager is one of the management tools for SQL Server. It shouldn't be installed on the server, only on client machines. If you have an installation disk for SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2008 at 2:27 am
John (4/9/2008)
1) It appears that all of the DATABASES that I want to work with MUST be in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder.
Only because that's where the SQL engine...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2008 at 12:39 am
No need to drop the table or the index
ALTER INDEX <Index name> ON <Table Name> REBUILD
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2008 at 12:19 am
What does the following query return?
select name, recovery_model_desc, log_reuse_wait_desc
from sys.databases where name = <Name of offending database>
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2008 at 12:07 am
Could you please have a look in the SQL error log (In object explorer) it'll be under Management ->SQL Server Logs.
Check to see what's there around the time you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2008 at 11:57 pm
karthikeyan (4/8/2008)
yes you are correct,we can seperate it in the DTS itself.But i want to do this with sql query.
Why?
The best way to split apart imported data is as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2008 at 2:26 pm
It varies by company and interviewer. I don't usually ask the same question in 2 different interviews.
I usually ask a couple of questions on indexes, at least one on execution...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2008 at 2:17 pm
Is this for a written interview test, or did someone ask you these?
If you're trying to memorise answers for an interview, don't. A good interviewer can see through that very...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2008 at 1:36 pm
If you open enterprise manager, and look down the bottom of the tree you should see SQLAgent.
Expand that out. The jobs are recorded under there.
Does that help?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2008 at 1:35 pm
Profiler won't show you anything. Profiler captures events sent to the server. When a tran log is restored, the SQL engine works through the tran log and just does the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 9, 2008 at 1:33 pm
Viewing 15 posts - 46,936 through 46,950 (of 49,552 total)