Forum Replies Created
Viewing 15 posts - 6,256 through 6,270 (of 49,552 total)
-
RE: Script for alter NonClustered Index to Custered across all databases
sudip.k.datta (4/2/2015)
But I am very new to SQL Server administration and from DBA team I have been told to alter non-clustered indexes to clustered for a list of tables.Go back...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: 50000 error executing stored process
sandeep1553 (4/2/2015)
Did you get the answer for this question. Because I am facing the same problem .If got the answer, please let me knowError 50000 is a user-defined error....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: COMMIT fixes problem - or will it create one?
Probably not, but without seeing the proc and having more details on the process, hard to say.
Just wrapping something in a transaction is seldom the answer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Unable to start the agent
Please don't post multiple threads for the same problem.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1673756-2799-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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Group by clause - question
This is one way, there are others
SELECT * FROM CompanyEmployeeArchive cea WHERE NOT EXISTS (SELECT 1 FROM CompanyEmployeeArchive c WHERE c.Employees >= 100 AND cea.Company = c.Company)Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: i have object with name "utils..deletelist" in my database .where can i find the same in the object explorer ? what kind of object it is ? is it a table or proc etc ...?
The name implies that there's a database named utils and within that database, in the dbo schema is an object called 'deletelist'. Check your server. As for what it is,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL Query - Possibly the most poorly written query in the history of mankind
mister.magoo (4/1/2015)
I see two choices.1. It is April 1st.
2. You win the prize for worst query ever.
My guess is that that is a cardinality estimation error, either from poor stats...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL Query - Possibly the most poorly written query in the history of mankind
Grant Fritchey (4/1/2015)
We don't start talking about how evil a query is until it breaks at least 10 printed pages.My worst
queryprocedure so far is 95 printed pages using...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Triggers
inserted = new rows for an insert and new values for an update.
deleted = deleted rows for a delete and old values for an update.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL Server 2008 Licensing
Yes, they need to be licensed.
If this user is doing development work, they can be developer edition, if the user is doing work with real data for business purposes,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Are the posted questions getting worse?
Grant Fritchey (4/1/2015)
SQLRNNR (4/1/2015)
Who remembered to do an April Fools post today?No inspiration for one this time.
No inspiration, no enthusiasm, no time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: couple of questions regarding Log Shipping
New Born DBA (4/1/2015)
where this uncommitted transaction come from?Transactions which were in progress during the backup.
Q. Why can't we have both DB online in log shipping? Is there...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: Deadlock involving query against sys.tables
ALTER INDEX is a DDL operation, therefore it will be making changes to the system tables, hence needing locks on the rows in the underlying metadata. Without seeing the deadlock...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: 9.3 GB bak won't restore to (10 GB limit) SQL Server Express 2008 R2
sufstuff01 (4/1/2015)
I am asking if there is a way to restore a read-only portion of the full backup that will fit inside the 10 GB limit so that I can...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: SQL excessive paging
Abhijit, get the following book, read through chapter 1 to start and apply what it discusses to your system. That should get you at least to the point of being...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 6,256 through 6,270 (of 49,552 total)