Forum Replies Created
Viewing 15 posts - 6,256 through 6,270 (of 49,571 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...
-
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....
-
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.
-
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
-
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) -
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,...
-
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...
-
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... -
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.
-
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,...
-
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.
-
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...
-
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...
-
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... -
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...
Viewing 15 posts - 6,256 through 6,270 (of 49,571 total)