Viewing 15 posts - 39,676 through 39,690 (of 49,552 total)
Wish (4/17/2009)
You said that cursor is working iteratively, My Question is that table variable is also works on iteration
Table variables work on iteration?
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 17, 2009 at 2:09 pm
Wrong place.
I'm talking about the windows accounts that the two services run as. First you need to find out what they are, check the services app from Administrative tools....
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 17, 2009 at 2:08 pm
Permissions?
Running through BI dev studio it'll be running under your credentials. Running as a SQL job it will be running either as the SQL Server service account or 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 17, 2009 at 12:19 pm
You should have a reasonable amount of experience with the product before writing the cert exam. If you have not worked on 2008 you will struggle with the 2008 exams....
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 17, 2009 at 12:14 pm
Winter's coming early here. It's already nippy enough in the evenings to require a jacket. That doesn't normally happen til May.
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 17, 2009 at 11:49 am
select d.name as DatabaseName, mf.name as FileLogicalName, mf.physical_name, type_desc, max_size
from sys.master_files mf inner join sys.databases d on d.database_id = mf.database_id
Any files with a max size of -1 are set...
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 17, 2009 at 11:30 am
Please post table definitions. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Is this for SQL 2000, 2005 or 2008? If 2005 or higher, look...
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 17, 2009 at 9:35 am
Steve Jones - Editor (4/17/2009)
Personally I don't answer questions in email at all. They need to post it somewhere.
Agreed, and that's the only reason I want to reply. I just...
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 17, 2009 at 9:24 am
Providing the log hasn't been backed up or truncated since the delete.
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 17, 2009 at 7:03 am
Same data volume?
Same indexes?
Same statistics?
Same execution plan?
Same number of concurrent users?
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 17, 2009 at 6:31 am
Unlikely. The default trace has a minimum of events. I don't believe that the DML events are among them. It would be just too much activity for what's supposed to...
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 17, 2009 at 5:32 am
Oh my, that is some frighteningly bad advice.
Backup log with truncate only? Shrink data files? Both with no mention of the downsides and consequences of them?
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 17, 2009 at 4:38 am
mithun.gite (4/17/2009)
See, anyone who sees the query can guess that its not the actual query to optimize,,
Then what was the point of posting it?
its just a matter of concept...
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 17, 2009 at 4:32 am
Kishore.P (4/17/2009)
krishrana17 (4/17/2009)
Thanks for replying...
Here is the Error message that i got when i m changing the identity column to "Yes" and save the changes.
Saving changes is not permitted....
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 17, 2009 at 3:58 am
mithun.gite (4/17/2009)
It is possible, one way i know which is pasted below, wanted to know anyone knows the other simple way????
Not in 2005. In SQL 2008 there's an easy way...
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 17, 2009 at 3:56 am
Viewing 15 posts - 39,676 through 39,690 (of 49,552 total)