Popular Posts

  • Error: 18056, Severity: 20, State: 23
    SQLServerCentral » Latest topics Error: 18056, Severity: 20, State: 23 Hi.. Error: 18056, Severity: 20, State: 23. Message The clie...
  • No More Service Packs
    SQLServerCentral » Latest topics No More Service Packs Comments posted to this topic are about the item [B] No More Service Packs [...
  • Report queque
    SQLServerCentral » Latest topics Report queque Does SSRS keep track of reporting running queues? If it does, where I can find it? T...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Thursday, December 7, 2017

SQL server agent (MSSQLSERVER) not starting after system reboot

SQLServerCentral » Latest topics
SQL server agent (MSSQLSERVER) not starting after system reboot
Hi,
We are using SQL2014 for our application on Windows 10 and Windows 2016 systems.  We are observing that SQL server agent is not starting after a reboot.  This issue is not observed with SQL2008 and windows 7 systems.
I have looked at
at No comments:

A simple example which, after 15 years of relational design work, still breaks my brain - phone numbers

SQLServerCentral » Latest topics
A simple example which, after 15 years of relational design work, still breaks my brain - phone numbers
Every so often I find myself needing to build schema for something which has very little complexity in the "real world", but where the model of that part of the world becomes more and more difficult the more I think about it. Maybe this is a symptom of ov
at No comments:

Couldn't create SSISDB catalog

SQLServerCentral » Latest topics
Couldn't create SSISDB catalog
Hi Every one,
 I have a issue that I couldn't create SSISDB catalog under the Integration Services Catalogs. The error message is " the catalog backup file 'C\Program file\...\SSISDBbackup.bak' could not be accessed. make sure the database file e
at No comments:

Design Input for ETL of OLTP Database

SQLServerCentral » Latest topics
Design Input for ETL of OLTP Database
Hello All - 

I wasn't sure exactly where my question fit, so thought i'd put it here first.  I just started a new contract position and am inheriting an existing design.  Here's the project:

My company wants to ETL/stage a
at No comments:

SQL Server 2016 Mirroring

SQLServerCentral » Latest topics
SQL Server 2016 Mirroring
Hi,
Can someone please confirm that SQL Server 2016 SP1 does or doesn't do mirroring,
at No comments:

DISTINCT FOR ONE COLUMN ONLY

SQLServerCentral » Latest topics
DISTINCT FOR ONE COLUMN ONLY
Guys,  how do i make the following only bring back one value for each REGNO? As you can see some of then are bring back 2 in the total column?  Select Distinct shows the same results.

Many thanks

at No comments:

ORDER By Based on Company then SubCompany

SQLServerCentral » Latest topics
ORDER By Based on Company then SubCompany
Hello,
Trying to create a selection in a specific order.
The table is like this
 
CompanyName , CompanyStatus, CompanyNumber, GroupNumber
Blackwell ,          group, &nb
at No comments:

Are the posted questions getting worse?

SQLServerCentral » Latest topics
Are the posted questions getting worse?
Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in charge of something who was asking how to take a database backup and restore it on another server. It seems like the general feeling of a lot
at No comments:

Scalar functions and performance drop off

SQLServerCentral » Latest topics
Scalar functions and performance drop off
Hi,
I have tried a few things now and I am not really getting anywhere. I have a database which is providing some relevancy scores basically telling me how useful a result is based on the range it falls within.
This uses many scalar functions to c
at No comments:

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]
at No comments:

Calculating varying process capacity

SQLServerCentral » Latest topics
Calculating varying process capacity
Hello again, SQL experts,

I'm facing an interesting challenge. I have a production process that runs from 8 AM to 7 PM. Process capacity is 750 units per hour *except* for the 11 AM to noon hour and the 3 PM to 4 PM hour, which each have a capaci
at No comments:

returning numeric value

SQLServerCentral » Latest topics
returning numeric value
Hello comunity
I need help for returning numeric values from dynamic sql. My script is
[code language="sql"]
   DECLARE @BD VARCHAR(40)
    DECLARE @myobrano INT
at No comments:

The Relational Database is the Default

SQLServerCentral » Latest topics
The Relational Database is the Default
Comments posted to this topic are about the item [B]The Relational Database is the Default[/B]
at No comments:

ASCII ProperCase Function

SQLServerCentral » Latest topics
ASCII ProperCase Function
Comments posted to this topic are about the item [B]ASCII ProperCase Function[/B]
at No comments:

SQL Server Restart - Reason

SQLServerCentral » Latest topics
SQL Server Restart - Reason
Hi there

We had sql server restarted unexpectedly and i am trying to find the reason. In my experience (I am not DBA) with SQL Server there is one instance in the past with different employer where the server restarted and DBA said it was because
at No comments:
Subscribe to: Posts (Atom)