Viewing 15 posts - 181 through 195 (of 496 total)
We will need some more information than what you have provided.
Are you currently experiencing issues with the production server?
What is the normal baseline for PLE on that server?...
February 12, 2014 at 8:55 am
Lowell is correct. To show the point I have created a user without a login to change the ownership of the RestrictedTable:-- Create a table that our test user will...
February 12, 2014 at 8:50 am
Jason was too quick for me. Guess that's what I get for typing out my code instead of having a blog post ready to go. 😀
February 11, 2014 at 12:33 pm
I would use something like this: with DupTable as (
select ID, ROW_NUMBER() over (partition by ID order by ID) as rn
from Table
group by ID
having count(*) > 1)
delete DupTable
where rn >...
February 11, 2014 at 12:32 pm
Please read the first article in my signature and following the recommend guidelines listed in there about posting these types of questions to the forum. After you have supplied the...
February 11, 2014 at 9:28 am
If I'm an employee I think I have the responsibility to let management know my concerns and make sure that I'm heard. I would create a project document listing any...
February 11, 2014 at 9:26 am
From my experience I would choose B. Without the proper buy-in and support it is a doomed project and will end up leaving a bad taste with senior management in...
February 11, 2014 at 9:18 am
Can you restore the database(s) to a test environment and run it there? If not, then is there a maintenance window that you could run during? It really depends on...
February 11, 2014 at 8:51 am
Luis Cazares (2/10/2014)
February 10, 2014 at 1:11 pm
Without the DDL for invoice I can't complete the query for you , but you could use a recursive CTE to populate the dates that you need into the table...
February 10, 2014 at 9:49 am
After you are done with the shrink operation make sure to kick off a rebuilding of the indexes. I would use Ola Hallengren's [/url]scripts.
February 10, 2014 at 9:35 am
On your publisher execute sp_helpsubscriberinfo with your new subscriber and publisher. If it is listed there then make sure that you have refreshed the "Local Subscriptions" folder on the Subscriber.
February 6, 2014 at 8:29 am
Minaz (2/6/2014)
We took out expensive queries and that was tunes and used a new sql plan. But after 3 hours same query became once again the expensive one.
How was performance...
February 6, 2014 at 8:20 am
Verify that you have the executable (Profiler.exe) in your binn directory: "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn". If not you may need to reinstall the tools.
This also could be a good...
February 6, 2014 at 8:13 am
I simply glossed over that fact that it was the same column :hehe: Just went off the OP request.
February 5, 2014 at 9:40 pm
Viewing 15 posts - 181 through 195 (of 496 total)