SQLServerCentral » Latest topics
Is This Database Being Used?
Comments posted to this topic are about the item [B]Is This Database Being Used?[/B]
Tuesday, December 5, 2017
Can Data Save the World?
SQLServerCentral » Latest topics
Can Data Save the World?
Comments posted to this topic are about the item [B]Can Data Save the World?[/B]
SSMS 2017 v3 - files open disconnected, no connection option
SQLServerCentral » Latest topics
SSMS 2017 v3 - files open disconnected, no connection option
Maybe I am just missing something, but when I double-click on a .sql file, it opens connected, or at least offers a choice.
When the same file is renamed .prc, it opens disconnected, and there is no way to make a connection.
Where is the set
When the same file is renamed .prc, it opens disconnected, and there is no way to make a connection.
Where is the set
SSRS reports Migration
SQLServerCentral » Latest topics
SSRS reports Migration
Hi,
We are want to migrate SQL Reporting service from SQL Server 2008 R2 to SQL Server 2016. New Reporting server up and running, now I want to move all RDL file to a new server because we have 750 reports in total I don't want to downl
We are want to migrate SQL Reporting service from SQL Server 2008 R2 to SQL Server 2016. New Reporting server up and running, now I want to move all RDL file to a new server because we have 750 reports in total I don't want to downl
Change Tracking Weird Result
SQLServerCentral » Latest topics
Change Tracking Weird Result
Hello
Is it normal a query like below to return any rows?
select RECID from CHANGETABLE(CHANGES PRICEDISCTABLE,0) C WHERE C.SYS_CHANGE_OPERATION = 'D'
intersect
select RECID from PRICEDISCTABLE
We don't normally e
Is it normal a query like below to return any rows?
select RECID from CHANGETABLE(CHANGES PRICEDISCTABLE,0) C WHERE C.SYS_CHANGE_OPERATION = 'D'
intersect
select RECID from PRICEDISCTABLE
We don't normally e
Today's Random Word!
SQLServerCentral » Latest topics
Today's Random Word!
HI
When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene or a word running through your mind...
Jump on that word...
And.
Post it here by it's thumbs! :hat: Quickly! Before it becomes a number!
How to manage and monitor large SQL Server estates
SQLServerCentral.com Articles
How to manage and monitor large SQL Server estates
Managing a couple of SQL Servers is a whole different ball game compared to managing 10’s or 100’s of servers. With so much available data to take in, this webinar will guide you through what’s important and what’s noise.
Monday, December 4, 2017
Agent Job fails on "sa" account login
SQLServerCentral » Latest topics
Agent Job fails on "sa" account login
I have a couple of SQL Server Agent jobs configured to run as "sa"
However, they fail with the error "Description: The Execute method on the task returned error code 0x80131904 (Login failed for user 'sa'.)."
Does SQL Server save a password w
However, they fail with the error "Description: The Execute method on the task returned error code 0x80131904 (Login failed for user 'sa'.)."
Does SQL Server save a password w
http://www.southafricasupplements.co.za/renuvaline/
SQLServerCentral » Latest topics
http://www.southafricasupplements.co.za/renuvaline/
Renuvaline:It mentions that the serum utilizes "peptide-rich leap forward recipe" to go into the most profound of your skin particles to evacuate
Item Price changes
SQLServerCentral » Latest topics
Item Price changes
I have a table where we store price information for each item and prices can be changed anytime during the month. How can I store and retrieve correct information based on price updates. Please check the below table structure and my query.
Can Data Save the World?
SQLServerCentral » Latest topics
Can Data Save the World?
Comments posted to this topic are about the item [B]Can Data Save the World?[/B]
Index Fragmentation
SQLServerCentral » Latest topics
Index Fragmentation
Hi everyone,
I am fighting with a SQL Server 2014 table [IR_RecordingMedia] (5.5GB data, 6.8GB Index, 11.6 million rows) that is running well, but my vendor for the software using the table says it needs to be reindexed due to results of the foll
I am fighting with a SQL Server 2014 table [IR_RecordingMedia] (5.5GB data, 6.8GB Index, 11.6 million rows) that is running well, but my vendor for the software using the table says it needs to be reindexed due to results of the foll
Subscribe to:
Posts (Atom)