Viewing 15 posts - 44,341 through 44,355 (of 49,552 total)
shishirbabel (9/21/2008)
What my main point is that i am not sure that which indexing to use to make sure that database responds in a very fast...
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
September 21, 2008 at 2:01 pm
Pleasure.
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
September 21, 2008 at 1:49 pm
You can use SQL profiler to capture all the commands that are run against a server. That won't tell you what rows were affected, it will just give you 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
September 21, 2008 at 1:47 pm
Yeah, if the DB is using features that were deprecated in SQL 2000 and removed in SQL 2005. They'll still work in compat mode 80
Old style joins come to mind...
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
September 21, 2008 at 1:46 pm
shishirbabel (9/21/2008)
Which type of indexing to be used for large databases having more then 100 tables and a capacity to hold more then 10,000,00 records in the system ?
That's...
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
September 21, 2008 at 1:36 pm
YSLGuru (9/21/2008)
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
September 21, 2008 at 1:26 pm
Versions of SQL 2005 prior to SP2 don't run properly on Vista and you have RTM there.
Can you download the SP2 version of express and install that over the version...
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
September 21, 2008 at 1:17 pm
Please connect to the edition that you're trying to create the diagrams on and run the following:
select @@version
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
September 21, 2008 at 11:58 am
Update all statistics after you move to 2005, run a DBCC updateusage and I would recommend a CheckDB as well.
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
September 21, 2008 at 10:22 am
If you're running 2005 on Vista, being the machine's admin does not guarantee that you are sysadmin in SQL server. You'll have to explicitly add yourself as admin to SQL.
If...
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
September 21, 2008 at 10:11 am
Nope.
That's true of most things in SQL. Once they're deleted, they're gone.
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
September 21, 2008 at 8:41 am
Looks like your login doesn't have create database privileges. Are you the admin of that server? If not, can you speak with the admin and see if you have 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
September 21, 2008 at 8:24 am
When you installed, did you check the option for the client tools? It should be checked by default.
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
September 21, 2008 at 8:22 am
shishirbabel (9/20/2008)
1. I am having lengthy tables of up to 50 columns but all these 50 columns will not contain any redundant values so is it a good idea 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
September 21, 2008 at 3:08 am
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums
No replies to this thread please, direct replies to:
http://www.sqlservercentral.com/Forums/Topic573066-361-1.aspx
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
September 21, 2008 at 3:02 am
Viewing 15 posts - 44,341 through 44,355 (of 49,552 total)