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...
  • sp_helpindex2
    SQLblog.com - The SQL Server blog spot on the web sp_helpindex2 --my extension of sp_helpindex: sp_helpindex2 USE master GO IF EXIS...
  • XML parsing: semicolon expected
    SQLServerCentral » Latest topics XML parsing: semicolon expected I know the "XML parsing: semicolon expected" error is a ...

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

Loading...

Thursday, August 31, 2017

Why Missing Index Recommendations Aren’t Perfect

SQLServerCentral.com Articles
Why Missing Index Recommendations Aren’t Perfect

Before you apply those little missing indexes, read this.

at No comments:

The Table Valued Constructor

SQLServerCentral » Latest topics
The Table Valued Constructor
Comments posted to this topic are about the item [B]The Table Valued Constructor[/B]
at No comments:

https://www.prohealthguides.com/keranique-hair-growth-reviews/

SQLServerCentral » Latest topics
https://www.prohealthguides.com/keranique-hair-growth-reviews/
Particularly in terms of hair loss troubles. Something you could do to reduce the stress for your lifestyles from reducing down the hours of your keranique  act
at No comments:

date fillers - dates in two rows

SQLServerCentral » Latest topics
date fillers - dates in two rows
Hello All,
I need a very efficient way to duplicate rows based on dates in rows. table structure is something as follows
CREATE TABLE #OutputResultSet                            
at No comments:

Display records horizontally

SQLServerCentral » Latest topics
Display records horizontally
Hi,
I'm creating a report that has to display values horizontally, the values need to be distinct and then comma delimited (but not the last one) and just 7 columns per row
I can't do a select distinct in my query, otherwise the ceiling-function (
at No comments:

first wife adopted in 1949 When

SQLServerCentral » Latest topics
first wife adopted in 1949 When
[url=https://www.linkedin.com/company/watch-ohio-state-vs-indiana-live-stream-free-ncaaf-week1]Ohio State vs Indiana Live Stream[/url]
at No comments:

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

script to run dbcc indexdefrag for all databases in a server.

SQLServerCentral » Latest topics
script to run dbcc indexdefrag for all databases in a server.
Hi all,
I'm trying to create a script to run dbcc indexdefrag not only for one database, but for all of my databases in my server.
I try the following:
[code language="sql"]
/*Perform a 'USE <dat
at No comments:

SSIS as an Execution Engine for Multiple Sql scripts

SQLServerCentral » Latest topics
SSIS as an Execution Engine for Multiple Sql scripts
Comments posted to this topic are about the item [B]SSIS as an Execution Engine for Multiple Sql scripts[/B]
at No comments:

Curious Case of SUM Function

SQLServerCentral » Latest topics
Curious Case of SUM Function
Comments posted to this topic are about the item [B]Curious Case of SUM Function[/B]
at No comments:

Appreciating New Perspectives

SQLServerCentral » Latest topics
Appreciating New Perspectives
Comments posted to this topic are about the item [B]Appreciating New Perspectives[/B]
at No comments:

The Adequate DBA

SQLServerCentral » Latest topics
The Adequate DBA
Comments posted to this topic are about the item [B]The Adequate DBA[/B]
at No comments:

script to run dbcc indexdefrag for all databases in a server.

SQLServerCentral » Latest topics
script to run dbcc indexdefrag for all databases in a server.
Hi all,
I'm trying to create a script to run dbcc indexdefrag not only for one database, but for all of my databases in my server.
I try the following:
[code language="sql"]
/*Perform a 'USE <dat
at No comments:

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

SSRS Default dates if statement

SQLServerCentral » Latest topics
SSRS Default dates if statement
Hi all,

Is there a way I can make reports default to a date via some kind of iff statement? What I am trying to achieve is if the from date is before 31st march in the current year then default the date to 1st april in the previous year, and if t
at No comments:

Database Development Made Easy?

SQLServerCentral » Latest topics
Database Development Made Easy?
Comments posted to this topic are about the item [B]Database Development Made Easy?[/B]
at No comments:

Query cancelled but completed is 0...

SQLServerCentral » Latest topics
Query cancelled but completed is 0...

Hey,
Just got another issue. One of our developers ran a BI query directly on the server and cancelled it after 15 Hrs as our daily full backup ran abnormally longer. It was an update on table with 30 million rows and has a join on another table wi

at No comments:

copying a database from one server instance to another server instance

SQLServerCentral » Latest topics
copying a database from one server instance to another server instance
I am trying to copy a database from one server instance to another server instance. Both instances are viewable in my SSMS session. I tried the wizard with no luck so I was hoping to do it with T-Sql. To avoid overwriting the production AAA_DB database I
at No comments:

Update Statistics..

SQLServerCentral » Latest topics
Update Statistics..

Hi Experts,
Trying to figure out if it might help in solving any performance issues by introducing an additional manual update job. To put it other way , how do I establish that the stats for a particular table have become stale ? We have auto

at No comments:

Anyway to find the row based on the page number

SQLServerCentral » Latest topics
Anyway to find the row based on the page number

Working with a  new client and on one of the DB's I am looking at has a consistency error on one of the tables.

I have dropped and rebuilt all of the indexes on the table and run a DBCC UPDATEUSAGE as the page counts where off for that ta

at No comments:

Compare database structure

SQLServerCentral » Latest topics
Compare database structure

Hi All

 

at No comments:

Installing SQL Server Agent on SUSE Linux

SQLServerCentral.com Articles
Installing SQL Server Agent on SUSE Linux

Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.

sqlmonitor How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.
at No comments:

Wednesday, August 30, 2017

What does LockTime out event , text data is interpreting ?

SQLServerCentral » Latest topics
What does LockTime out event , text data is interpreting ?
Hi,
On review the traces, I see multiple lock:Timeout, with text data as 6:2161, 4:1944 with some binarydata :0X710800000600000000000000020006

I have searched a lot on Internet but not getting the clue of what useful information I can derive
at No comments:

http://www.healthyapplechat.com/nouvelle-beaute-serum/

SQLServerCentral » Latest topics
http://www.healthyapplechat.com/nouvelle-beaute-serum/
Nouvelle beaute serum:Other than that, there are numerous other critical capacities that this healthy skin serum really performs and hence make
at No comments:

SSIS as an Execution Engine for Multiple Sql scripts

SQLServerCentral » Latest topics
SSIS as an Execution Engine for Multiple Sql scripts
Comments posted to this topic are about the item [B]SSIS as an Execution Engine for Multiple Sql scripts[/B]
at No comments:

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

List all logins, databases, role mapping

SQLServerCentral » Latest topics
List all logins, databases, role mapping
Hi there, I'm looking for a query or script that can generate a list of all SQL Server login's on an instance, along with all the roles they are mapped to on what databases. I'm new to SQL Server and am unaware of what system views or tables I can use to
at No comments:

Returning Measure from Dim Date.

SQLServerCentral » Latest topics
Returning Measure from Dim Date.
Good day all,
I have the 2 tables, one containing the Fact transaction while other is the date Dimension.

Am able to build the the following DAX columns in the Date Dimension

1. [code language
at No comments:

Can Uber, Lyft, and Waze Save Lives in Natural Disasters?

SQLblog.com - The SQL Server blog spot on the web
Can Uber, Lyft, and Waze Save Lives in Natural Disasters?
After working as a registered nurse and volunteer firefighter during hurricane Harvey, I came up with ideas on how Uber, Lyft, and Waze could help. See my article on LinkedIn here ....(read more)
at No comments:

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

Determining causes for performance difference in queries

SQLServerCentral » Latest topics
Determining causes for performance difference in queries
Hi,
We have an integration query running at 5am - simple view on 3 tables (2 tables have 4-6m rows) -  on some days the client extracts data in 4 minutes and in some days it can be 30-40 minutes.
The base tables being queried are re-built eve
at No comments:

Determine Monday of next month and Monday of next week

SQLServerCentral » Latest topics
Determine Monday of next month and Monday of next week

I am trying to determine the first Mondayof the next Month when the first Monday of this month has passed. Also the samefor a Mond

at No comments:

Finding Consecutive Values For a Record

SQLServerCentral » Latest topics
Finding Consecutive Values For a Record
I have a table that shows if a record has a value for each month.  A zero is given for that particular month to show there is no value.  Below is an example of how the table looks:

at No comments:

Time increments

SQLServerCentral » Latest topics
Time increments
Hi,

I want to have a calculated field "TimeIncrements' that will increment 20 minutes starting at 8:00 and ending at 5:00 using sort order FieldSort1 ,FieldSort2  and FieldSort3

at No comments:

security admin/db_security admin role permission issue

SQLServerCentral » Latest topics
security admin/db_security admin role permission issue

Hi Team,

I have a user who has securityadmin server role and db_securityadmin permission on the databases as well.

However, when this user trying creating new user and map to user database, getting the below error.  Any idea what

at No comments:

Database Development Made Easy?

SQLServerCentral » Latest topics
Database Development Made Easy?
Comments posted to this topic are about the item [B]Database Development Made Easy?[/B]
at No comments:

Create a database from backup when the backup transaction log is damage.

SQLServerCentral » Latest topics
Create a database from backup when the backup transaction log is damage.
Good day everyone.

I would like to know if it possible to restore a dump file to create a database even if the backup transaction log is damage.
Can the transaction log from the backup be skipped and a new transaction log be created once the
at No comments:

Solved - Can I join these tables with a query to obtain the final result?

SQLServerCentral » Latest topics
Solved - Can I join these tables with a query to obtain the final result?
Hi all,

I'm wrapping my head around a problem that I'm not being able to solve. Perhaps one of you might know what I'm failing to understand.

I have 3 tables:

at No comments:

A Logical Consistency-Based I/O Error

SQLServerCentral » Latest topics
A Logical Consistency-Based I/O Error
Hi all,
Here's my problem:
I cannot connect tp SQL Server. Getting this error message:
Sql Server Detected A Logical Consistency-Based I/O Error: Incorrect Checksum. (Microsoft SQL Server, Error:824)

Any thoughts please?
Thanks
at No comments:

Replication alternatives for SQL Server 2016 Web Edition

SQLServerCentral » Latest topics
Replication alternatives for SQL Server 2016 Web Edition
We have a SQL Server 2016 Web Edition instance that we ideally need to replicate a subset of data from. However, Web Edition only supports replication as a subscriber, not as a publisher. The cost of upgrading to Standard Edition does not make business se
at No comments:

Performance tuning, alternative to cursors for my situation?

SQLServerCentral » Latest topics
Performance tuning, alternative to cursors for my situation?
Hi everyone,

I'm trying to come up with something that is better performance-wise with a stored procedure I've built. I'm not going to go into too much detail but here's a summary:

I've got a Client_merge table containing two columns: Ma
at No comments:

Sessions and preconference at Microsoft Ignite and PASS Summit

SQLblog.com - The SQL Server blog spot on the web
Sessions and preconference at Microsoft Ignite and PASS Summit

I recently published a new blog post on SQLBI.

You can read it at this link: http://www.sqlbi.com/blog/marco/2017/08/30/sessions-and-preconference-at-microsoft-ignite-and-pass-summit/

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:

Sql Cannot establish new connection

SQLServerCentral » Latest topics
Sql Cannot establish new connection
I have Sql Server 2016 running on windows server 2016 (Microsoft SQL Server 2016 (SP1-CU3) (KB4019916) - 13.0.4435.0 (X64)  Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 6.3 <X64> (Build 14393: ) (Hypervisor)
)
Server is
at No comments:

Case and replace

SQLServerCentral » Latest topics
Case and replace
Hi,

I have got a number of records that begin with 044, I need to replace that with 0. I am using this replace(cli,'044','0'), however some records are 044123044 and so it replaces the end of the record with 0 also.  How can I get it to just
at No comments:

Dynamically read images from share path and display in report

SQLServerCentral » Latest topics
Dynamically read images from share path and display in report
Hi 
Will it be possible to display the images in SSRS from FTP path ?

Two table invoice  & image_info
-- table invoice
Invoice number and other info
123,.......
124,.......
--table image_info
Invoi
at No comments:

Join with Same table

SQLServerCentral » Latest topics
Join with Same table
Hi All,
 I have below scenario

There are Two tables:

[code language="sql"]
CREATE TABLE DBO.TBLORDERTYPE
(ID INT IDENTITY(1,1),
TYPE_DESC VARCHAR(20))

CREATE TABLE
at No comments:

Comic for 2017.08.30

RSSMix.com Mix ID 8239024
Comic for 2017.08.30
New Cyanide and Happiness Comic
at No comments:

Tuesday, August 29, 2017

How to Find Out Which Database Object Got Deleted

SQLServerCentral.com Articles
How to Find Out Which Database Object Got Deleted

Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.

at No comments:

The Azure Data Lake Catalog

SQLServerCentral » Latest topics
The Azure Data Lake Catalog
Comments posted to this topic are about the item [B]The Azure Data Lake Catalog[/B]
at No comments:

Houston, Hurricane Harvey, and Technology

SQLblog.com - The SQL Server blog spot on the web
Houston, Hurricane Harvey, and Technology
Many people are staying in shelters after being displaced by the flooding caused by hurricane Harvey. There were requests made for mental health professionals to go to shelters and talk to people who need help. People with professional credentials were willing to help. Floodwaters prevented some of the willing and qualified to be able to get to the shelters. This seems like a great use of telehealth technology....(read more)
at No comments:

Trying To filter Data using LAG() and LEAD() functions

SQLServerCentral » Latest topics
Trying To filter Data using LAG() and LEAD() functions
sir ,
i am stuck in one problem . USING LAG() AND LEAD() FUNCTIONS
trying to filter the data as per the requirement .
Attaching the table script with data .
Lin
at No comments:

Handling Transactions - Try/Catch - Error

SQLServerCentral » Latest topics
Handling Transactions - Try/Catch - Error

I have posted a similar question few days, i thought i got it but after i made code changes things broke again , so here i am again :).
Below is pseudo code of what i am trying to do. I have few things to
at No comments:

Columns to rows and rows to column conversion without pivot/unpivot

SQLServerCentral » Latest topics
Columns to rows and rows to column conversion without pivot/unpivot
All I need is convert Column(A1/A2) into rows and rows(1 into Jan) into columns.Input:

Here A1/A2 belongs to say A and they are calculated as A1/A2 for each month.

at No comments:

Database Development Made Easy?

SQLServerCentral » Latest topics
Database Development Made Easy?
Comments posted to this topic are about the item [B]Database Development Made Easy?[/B]
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:

do you have a StripNonNumeric ITVF function?

SQLServerCentral » Latest topics
do you have a StripNonNumeric ITVF function?
we all know Inline Table Value Functions perform at least a couple of order of magnitude faster than a scalar function, but there are some functions I have in my collection that are scalar, that , so far, I don't have an ITVF equivilent for. I've got a
at No comments:

Query Help

SQLServerCentral » Latest topics
Query Help
Here is the basic schema of table
CREATE TABLE Test (ID INT, ProductCode VARCHAR(50), Quantity INT)

INSERT INTO Test
SELECT 1,'ABC', 1
UNION
SELECT 2, 'DEF', 2
UNION
SELECT 3, 'GEH', 1
UNION
SELECT 4, 'XYZ', 3
at No comments:

Who's Responsible?

SQLServerCentral » Latest topics
Who's Responsible?
Comments posted to this topic are about the item [B]Who's Responsible?[/B]
at No comments:

running stored procedure in a loop to get Top level Demand(s) form a Supply

SQLServerCentral » Latest topics
running stored procedure in a loop to get Top level Demand(s) form a Supply
i would like to create a stored procedure to find the Top Level Demand for a Supply .
I have a stored procedure which gives the demand for the passed Supply Matl Tag. Aim is to loop through this stored procedure to find the top level Demand.
Note
at No comments:

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

SSIS Package Permission Proxy Account

SQLServerCentral » Latest topics
SSIS Package Permission Proxy Account
I have an issue that I can't get around, I had a working solution but something got changed somewhere and now its broken.

I have an ssis file package that that uses an AD account to connect to another server and move data.

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:

Object Level Recovery Tool

SQLServerCentral » Latest topics
Object Level Recovery Tool
I'm looking for an Object Level Recovery Tool. The only references I've found by searching online is for Red Gate's tool that is no longer supported. Idera also had a tool called SQL Virtual Database but it doesn't appear to be available anymore either. I
at No comments:

Graphing Performance

SQLServerCentral » Latest topics
Graphing Performance
Comments posted to this topic are about the item [B]Graphing Performance[/B]
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:

Query Help

SQLServerCentral » Latest topics
Query Help
Here is the basic schema of table
CREATE TABLE Test (ID INT, ProductCode VARCHAR(50), Quantity INT)

INSERT INTO Test
SELECT 1,'ABC', 1
UNION
SELECT 2, 'DEF', 2
UNION
SELECT 3, 'GEH', 1
UNION
SELECT 4, 'XYZ', 3
at No comments:

Who's Responsible?

SQLServerCentral » Latest topics
Who's Responsible?
Comments posted to this topic are about the item [B]Who's Responsible?[/B]
at No comments:

Setting up New Sql Server

SQLServerCentral » Latest topics
Setting up New Sql Server
A company we are developing for have purchased a new Server
There will be about 4 users
Trying to install SqlServer 2016 (and 2014) but both failed after installing for about 30 minutes
The log file is very big and its difficult to see why it
at No comments:

general question on query performance

SQLServerCentral » Latest topics
general question on query performance
Hi All,

This is a generic question regarding query optimization.The query is working fine yesterday i.e. it was running for more than 5 mins. After looking at the actual plan todo I see the statistics are off once again. When I try to run the sam
at No comments:

Strange transaction log activity

SQLServerCentral » Latest topics
Strange transaction log activity
I'm suddenly seeing unusually large transaction log backups for a small database, and the application team swears that nothing has changed on their side. Can anybody help me work out what I've missed please?

- The database is in full recovery mod
at No comments:

Comic for 2017.08.29

RSSMix.com Mix ID 8239024
Comic for 2017.08.29
New Cyanide and Happiness Comic
at No comments:

Extending DevOps practices to SQL Server databases with Redgate, Git & Jenkins

SQLServerCentral.com Articles
Extending DevOps practices to SQL Server databases with Redgate, Git & Jenkins

Join Microsoft Data Platform MVP, Grant Fritchey, for our next Database DevOps demo webinar. He’ll be plugging Redgate’s tools into Git and Jenkins to show you how Redgate's Database DevOps solution helps you build, test and deploy your database changes alongside your app code.

sqlmonitor How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.
at No comments:

Monday, August 28, 2017

SSAS Data Source Impersonation Information

SQLServerCentral » Latest topics
SSAS Data Source Impersonation Information
Good Moring, 

Currently I am writing my Bachelor Thesis. As part of this, I have to set up a Data Warehouse. Due to I use SSIS to transfom Flat-files into a SQL Server 2017 database. In the next step I want to use them as data source for an
at No comments:

http://www.healthitcongress.com/prime-ageless-serum/

SQLServerCentral » Latest topics
http://www.healthitcongress.com/prime-ageless-serum/
Prime ageless serum: is an age-resisting skincare equation that can essentially enhance your appearance when you add it to your day by day skinca
at No comments:

Incremental Package Deployment – A SSIS 2016 Feature

SQLServerCentral » Latest topics
Incremental Package Deployment – A SSIS 2016 Feature
Comments posted to this topic are about the item [B]Incremental Package Deployment – A SSIS 2016 Feature[/B]
at No comments:

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

Install SQL Server Named Instance using silent install PowerShell

SQLServerCentral » Latest topics
Install SQL Server Named Instance using silent install PowerShell
Hi
Does anyone works on SQL Server Named install using PowerShell using .ini files?
If you have any runnable script please share.

Basically want to have the flexibility of both default and named install based on switch option it will work
at No comments:

Calculating averages

SQLServerCentral » Latest topics
Calculating averages
I have the following sql code that gets me Total no of days taken for each workflow step to process: I trying to get averages of how many days an enrollment takes to complete a particular workflow step for each program,

at No comments:

A Data ID

SQLServerCentral » Latest topics
A Data ID
Comments posted to this topic are about the item [B]A Data ID[/B]
at No comments:

Install SQL Server Named Instance using silent install PowerShell

SQLServerCentral » Latest topics
Install SQL Server Named Instance using silent install PowerShell
Hi
Does anyone works on SQL Server Named install using PowerShell using .ini files?
If you have any runnable script please share.

Basically want to have the flexibility of both default and named install based on switch option it will work
at No comments:

a bit or that have been clarified

SQLServerCentral » Latest topics
a bit or that have been clarified
[url=https://www.linkedin.com/company/watch-game-of-thrones-season-7-episode-7-online-free-got-s7e7]Game of Thrones Season 7 Episode 7 Online[/url]
at No comments:

Comic for 2017.08.28

RSSMix.com Mix ID 8239024
Comic for 2017.08.28
New Cyanide and Happiness Comic
at No comments:

Biztalk DBs in compatibility mode

SQLServerCentral » Latest topics
Biztalk DBs in compatibility mode
Hi,

Has anyone ever tried running BizTalk with the DBs in a lower compatibility mode?

We are currently on Biztalk 2010 with no plans to upgrade (we're trying to get rid of it) , but the latest version of SQL it runs on is
at No comments:

Importing data reports data truncation in both EM and SSIS from multiple data sources

SQLServerCentral » Latest topics
Importing data reports data truncation in both EM and SSIS from multiple data sources
First, I'm retired so have time to play with my own data.  I have two data sources, an extensive collection of digital music files and many years of financial data.

I use a program called MP3tag to load and export to .CSV files the TAG data
at No comments:

Full text search with Contains function

SQLServerCentral » Latest topics
Full text search with Contains function
Hello All, I have one field in the database table having the value for eg as "Wilson,Gregory T". In my SP there is one parameter @EmployeeName.When I pass the above exact string then it will returns me one record which is fine. Now I want to search
at No comments:

AlwaysON 2014 Mulit Site Failover Cluster keep alerts and losing database connection

SQLServerCentral » Latest topics
AlwaysON 2014 Mulit Site Failover Cluster keep alerts and losing database connection
Please help , i see the critical alerts in the cluster events log mainly below one. Also when the Application trying to connect it keeps failing . Logs show that the Database connection is closed 

Current Configuration HA site Node A and Nod
at No comments:

Job reported: Unable to terminate process (reason: Access is denied)

SQLServerCentral » Latest topics
Job reported: Unable to terminate process (reason: Access is denied)
Using SQL Server 2016 SP1 running on VM a SQLAgent job is hanging on one step that executes an SSIS package most executions.  The SQL Server Agent Error Log shows the subject line message with jobname, step, and process name inserted but no othe
at No comments:

Script or Ways to check if SSRS encryption key backed up

SQLServerCentral » Latest topics
Script or Ways to check if SSRS encryption key backed up
Hi Experts,
         Can anybody help me finding out how to check if the SSRS encryption key have been backup up successfully.
Is there any system table which contains this information? 

Thanks in advance,
at No comments:

Local #dax measures in #powerbi reports are not visible from #Excel

SQLblog.com - The SQL Server blog spot on the web
Local #dax measures in #powerbi reports are not visible from #Excel

I just published a new blog post on SQLBI. You can read it at this link: http://www.sqlbi.com/blog/marco/2017/08/28/local-dax-measures-in-powerbi-reports-are-not-visible-from-excel/

at No comments:

Help me with the SQL syntax

SQLServerCentral » Latest topics
Help me with the SQL syntax
Good Day!
What I need is a SQL syntax that will display the start and end date for each time span when the member was associated with a certain group.

So if you look in my code I have listed how the output should look like....

Help i
at No comments:

AVG Disk Transfer goes out of scale randomly

SQLServerCentral » Latest topics
AVG Disk Transfer goes out of scale randomly
Hi there guys.

I bring to you this strange situation where a Disk D would go out of scale (AVG DISK SEC/TRANSFER) for a couple minutes, up to the point that the system freezes, until it finally stops several minutes after:
at No comments:

Column name assignment

SQLServerCentral » Latest topics
Column name assignment
Comments posted to this topic are about the item [B]Column name assignment[/B]
at No comments:

Installed SS 2016, unable to find default instance or create one

SQLServerCentral » Latest topics
Installed SS 2016, unable to find default instance or create one
I have just installed SQL Server 2016 and SSMS 2016 on a virtual machine/server. I'm not sure how to find or create a SQL Server Instance, or find the default instance. On this server I'll be moving several databases from another named server running SQL
at No comments:

Logshipping Shipping- Regular LOG BACKUP

SQLServerCentral » Latest topics
Logshipping Shipping- Regular LOG BACKUP
Hi Experts,

In our environment we have configured the logshipping for all database, whether it is enough or we can schedule the logbackup hourly to avoid the log growth. Whether it can be done or not?? Is it required??

Regards
Narine
at No comments:

Error on Backup

SQLServerCentral » Latest topics
Error on Backup
I am getting a backup failure on a TDE database (SQL Server 2016 SP1 EE) in an AG

Msg 33111, Level 16, State 3, Line 1
Cannot find server certificate with thumbprint XXXXXXXXXXX
Msg 3013, Level 16, State 1 Line 1
Backup Database is te
at No comments:

TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources

SQLServerCentral » Latest topics
TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources
Comments posted to this topic are about the item [B]TDS Remoting: A Better Way to Create Linked Servers for ODBC Sources[/B]
at No comments:

solved - Row Level Security based on membership in AD Group or ServerRole

SQLServerCentral » Latest topics
solved - Row Level Security based on membership in AD Group or ServerRole
Hi,

I'd like to implement row LevelSecurity.

Users are mapped to one (or more!!!) Groups (either AD Groups or ServerRoles, does not matter which to use)
Each Group should only see the SalesFacts for the corresponding Company.
How
at No comments:

SQLCMD Mode; Run all SQL files in a directory

SQLServerCentral » Latest topics
SQLCMD Mode; Run all SQL files in a directory
Comments posted to this topic are about the item [B]SQLCMD Mode; Run all SQL files in a directory[/B]
at No comments:

Sunday, August 27, 2017

Testing COALESCE with tSQLt

SQLServerCentral.com Articles
Testing COALESCE with tSQLt

Learn how you can use tSQLt to test your COALESCE queries.

at No comments:

Tuesday evening amidst these many

SQLServerCentral » Latest topics
Tuesday evening amidst these many
[url=https://www.facebook.com/events/136625003618479/]US Open 2017 Live Stream[/url]
at No comments:

A Data ID

SQLServerCentral » Latest topics
A Data ID
Comments posted to this topic are about the item [B]A Data ID[/B]
at No comments:

Script or Ways to check if SSRS encryption key backed up

SQLServerCentral » Latest topics
Script or Ways to check if SSRS encryption key backed up
Hi Experts,
         Can anybody help me finding out how to check if the SSRS encryption key have been backup up successfully.
Is there any system table which contains this information? 

Thanks in advance,
at No comments:

Excel file (percent data type) to SQL table (vafrchar16) error

SQLServerCentral » Latest topics
Excel file (percent data type) to SQL table (vafrchar16) error

Tried to load excel file to sql table

dataflow task is failing because of data truncation error, in my source excel file it is % data type actual values are "2.35%"

in my sql table it is varchar(16) but it is failing with eerrror "Data trun

at No comments:

When you migrate a database to the same SQL build, but a new environment, post migration tasks?

SQLServerCentral » Latest topics
When you migrate a database to the same SQL build, but a new environment, post migration tasks?
Hello everyone,

I was curious as to peoples take on the following...

Lets say you have to move a database to a different network and domain, it could even be an Azure Virtual Machine in the cloud. Now normally, you'd migrate a database t
at No comments:

Comic for 2017.08.27

RSSMix.com Mix ID 8239024
Comic for 2017.08.27
New Cyanide and Happiness Comic
at No comments:

Does HIPAA require that test data not have any real data?

SQLServerCentral » Latest topics
Does HIPAA require that test data not have any real data?
This is a question that I'd ask in a free form forum, but I couldn't find one. If I've missed it, please forgive me.

Yesterday at work we had a rude surprise sprung on us. Or perhaps I should say the DBA's did, but it will effect me as well. The
at No comments:

After drinking it, she confesses to

SQLServerCentral » Latest topics
After drinking it, she confesses to
[url=https://architizer.com/projects/game-of-thrones-season-7-episode-7-online-stream-1/]Game Of Thrones Season 7 Episode 7 Online Stream[/url]
at No comments:

In January 2006, David Benioff had

SQLServerCentral » Latest topics
In January 2006, David Benioff had
[url=https://architizer.com/firms/watch-so7e7-game-of-thrones-season-7-episode-7-online-stream-full-hd-preview-here/]Game Of Thrones Season 7 Episode 7 Online Stream[/url]
at No comments:

Find out Who stopped SQL server service ?

SQLServerCentral » Latest topics
Find out Who stopped SQL server service ?
Hi All,

Is there any way to find out who stopped SQL service ?

I went through SQL log and windows event log , but unable to trace who stopped service.

In Windows log I can see log for sql service terminating but in user field it
at No comments:

the whole - or even half

SQLServerCentral » Latest topics
the whole - or even half
[url=https://wespeke.zendesk.com/hc/en-us/community/posts/115010203066--LIVE-HD-Bengals-vs-Redskins-L-i-v-e-S-t-r-e-a-m-i-n-g-O-n-l-i-n-e-FedEx-]Bengals vs Redskins Live Streaming[/url]
at No comments:

PLE

SQLServerCentral » Latest topics
PLE
Hi All, Appreciate if anybody can help understand why the physical memory is divided by 4 to determine ideal Page Life Expectancy.. Thank you..
at No comments:

Does HIPAA require that test data not have any real data?

SQLServerCentral » Latest topics
Does HIPAA require that test data not have any real data?
This is a question that I'd ask in a free form forum, but I couldn't find one. If I've missed it, please forgive me.

Yesterday at work we had a rude surprise sprung on us. Or perhaps I should say the DBA's did, but it will effect me as well. The
at No comments:

Left outer join make duplicate column name

SQLServerCentral » Latest topics
Left outer join make duplicate column name
I used code below to select 10 temp tables as one row table.
All 10 tables has the same column [FileID].
How to make final table only list one [FileID] column?
SELECT DISTINCT
   *
  FROM #1 A01
   LEFT O
at No comments:

high writelog wait on OLTP system and fast SSD storage, log flush is slow

SQLServerCentral » Latest topics
high writelog wait on OLTP system and fast SSD storage, log flush is slow
we have recently upgraded from SQL server 2008 to new servers and upgraded to sql server 2016 (SP1 CU3)

new servers hardware hp proliant 580G8 , 4 socket intel xeon E7 processor, total 60 cores, 640GB ram, 8 intel SSD S3700 Raid 0, local
at No comments:

Lookup values similar to VLookUp in Excel

SQLServerCentral » Latest topics
Lookup values similar to VLookUp in Excel
Hi,
I am struggling to write a procedure which looks up a value in a lookup table.
See desired results below.
Any suggestions?
Cheers,
Julian


[code language="sql"]
LOOKUP TABLE
at No comments:

PLE

SQLServerCentral » Latest topics
PLE
Hi All, Appreciate if anybody can help understand why the physical memory is divided by 4 to determine ideal Page Life Expectancy.. Thank you..
at No comments:

Installed SS 2016, unable to find default instance or create one

SQLServerCentral » Latest topics
Installed SS 2016, unable to find default instance or create one
I have just installed SQL Server 2016 and SSMS 2016 on a virtual machine/server. I'm not sure how to find or create a SQL Server Instance, or find the default instance. On this server I'll be moving several databases from another named server running SQL
at No comments:

Trying to create function to create folders (and sub folders)

SQLServerCentral » Latest topics
Trying to create function to create folders (and sub folders)
I'm using sp_OACreate in a scalar function to create a folder if it doesn't exist, and it works fine if you're asking it to create a single folder. For instance: C:\Newfolder It creates "Newfolder" However, if I try to ask it to create C:\Newfolder
at No comments:

Saturday, August 26, 2017

How to do this in one sql statement without CTE ?

SQLServerCentral » Latest topics
How to do this in one sql statement without CTE ?
I am able to query  Total number of Devices  from below CTE. 

[code language="sql"]
with Alarmreport (ID,SiteName,DEVICENAME)
at No comments:

Does HIPAA require that test data not have any real data?

SQLServerCentral » Latest topics
Does HIPAA require that test data not have any real data?
This is a question that I'd ask in a free form forum, but I couldn't find one. If I've missed it, please forgive me.

Yesterday at work we had a rude surprise sprung on us. Or perhaps I should say the DBA's did, but it will effect me as well. The
at No comments:

Columns to rows and rows to column conversion without pivot/unpivot

SQLServerCentral » Latest topics
Columns to rows and rows to column conversion without pivot/unpivot
All I need is convert Column(A1/A2) into rows and rows(1 into Jan) into columns.Input:

Here A1/A2 belongs to say A and they are calculated as A1/A2 for each month.

at No comments:

The art of getting it right

SQLServerCentral » Latest topics
The art of getting it right
Comments posted to this topic are about the item [B]The art of getting it right[/B]
at No comments:

Comic for 2017.08.26

RSSMix.com Mix ID 8239024
Comic for 2017.08.26
New Cyanide and Happiness Comic
at No comments:

couple of other potential

SQLServerCentral » Latest topics
couple of other potential
[url=http://cie.fcsh.espol.edu.ec/sites/default/files/Mayweather-vs-McGregor-Live-Stream-Boixng-ScoresRound-by-Round-26-August-2017-Showtime-Fight.pdf]Mayweather vs McGregor Live Streaming[/url]
at No comments:

PLE

SQLServerCentral » Latest topics
PLE
Hi All, Appreciate if anybody can help understand why the physical memory is divided by 4 to determine ideal Page Life Expectancy.. Thank you..
at No comments:

Lookup values similar to VLookUp in Excel

SQLServerCentral » Latest topics
Lookup values similar to VLookUp in Excel
Hi,
I am struggling to write a procedure which looks up a value in a lookup table.
See desired results below.
Any suggestions?
Cheers,
Julian


[code language="sql"]
LOOKUP TABLE
at No comments:

master key error when migrating SSISDB

SQLServerCentral » Latest topics
master key error when migrating SSISDB
I have a production SQL Server down for migration to a new SQL instance. I'm attempting to migrate SSISDB to a new server. I do not have the initial password used to create/encrypt the key. I'm using the processes in the links below. I have used this p
at No comments:

COUNT(*) vs SUM()

SQLServerCentral » Latest topics
COUNT(*) vs SUM()
All,
I've been asked to improve the performance of a moderately complicated query.  Here's the very simplified query:

SELECT
    EmployeeID
    ,NULL Referrals
    
at No comments:

how to perform update

SQLServerCentral » Latest topics
how to perform update
Hello everyone

I'll get right to the point.
I have the following script:
create table #tempData(recid    int identity(1,1), EDI_tekst nvarchar(4000), LineNum int, Chunk int not null default 0);

insert into #t
at No comments:

SQL Server Reporting Services

SQLServerCentral » Latest topics
SQL Server Reporting Services
I have only Reporting Services installed on dedicated server.Looking to apply service pack. Where do i find the service packs for reporting service only?
at No comments:

Does HIPAA require that test data not have any real data?

SQLServerCentral » Latest topics
Does HIPAA require that test data not have any real data?
This is a question that I'd ask in a free form forum, but I couldn't find one. If I've missed it, please forgive me.

Yesterday at work we had a rude surprise sprung on us. Or perhaps I should say the DBA's did, but it will effect me as well. The
at No comments:

Columns to rows and rows to column conversion without pivot/unpivot

SQLServerCentral » Latest topics
Columns to rows and rows to column conversion without pivot/unpivot
All I need is convert Column(A1/A2) into rows and rows(1 into Jan) into columns.Input:

Here A1/A2 belongs to say A and they are calculated as A1/A2 for each month.

at No comments:

The Adequate DBA

SQLServerCentral » Latest topics
The Adequate DBA
Comments posted to this topic are about the item [B]The Adequate DBA[/B]
at No comments:

datediff plus n days

SQLServerCentral » Latest topics
datediff plus n days

Hi

The below code looks at the first time an identifier (customer) has requested re activation of their account to completion and the messages which occurred in-between.

at No comments:

Lookup values similar to VLookUp in Excel

SQLServerCentral » Latest topics
Lookup values similar to VLookUp in Excel
Hi,
I am struggling to write a procedure which looks up a value in a lookup table.
See desired results below.
Any suggestions?
Cheers,
Julian


[code language="sql"]
LOOKUP TABLE
at No comments:

Why did added partitions make cube processing slower?

SQLServerCentral » Latest topics
Why did added partitions make cube processing slower?
We have a cube based on a 300 Million
at No comments:

Nested sub queries with SUM, optional parameters in Storedprocedure

SQLServerCentral » Latest topics
Nested sub queries with SUM, optional parameters in Storedprocedure
Hi,
The following storedprocedure (seems) to work fine when I supply all the optional parameters.
But if I leave out (ie don't supply a value) the parameter @IDAfd for example, no records are returned.
at No comments:

Warning on Job history

SQLServerCentral » Latest topics
Warning on Job history
Hi, I would like to know how to get (in a script) the status "WARNING" which is displayed in the job history : when a step is failed but the job is success. thx regards, SC
at No comments:

Friday, August 25, 2017

http://www.healthitcongress.com/la-mer-timeless-serum/

SQLServerCentral » Latest topics
http://www.healthitcongress.com/la-mer-timeless-serum/
La mer timeless serum:La Mer Timeless Serum is extraordinary compared to other age resisting items that will help you to accomplish imperishabl
at No comments:

http://xtrfact.com/ultimate-testo-explosion/

SQLServerCentral » Latest topics
http://xtrfact.com/ultimate-testo-explosion/
I bet we would all need the ripped appearance, however are you willing to work to get that appearance. I understand in my advancing years, Ultimate Testo Explosion i do not think so, but if you ar
at No comments:

SQLCMD Mode; Run all SQL files in a directory

SQLServerCentral » Latest topics
SQLCMD Mode; Run all SQL files in a directory
Comments posted to this topic are about the item [B]SQLCMD Mode; Run all SQL files in a directory[/B]
at No comments:

client server issue

SQLServerCentral » Latest topics
client server issue
Hi,
on My development where my sample website(developed on .net framework 4.6) hosted on IIS has  server TLS1.2 enabled and TLS1.1,1.0 disabled. when it connects to my db server which is 2008 R2(RTM) SP1 , i am unable to connect and it says clien
at No comments:

Looping Challege

SQLServerCentral » Latest topics
Looping Challege
Hi,
I have an interesting project.  I need to show materials that make up parts then find materials that make up those materials that they are composed of if any.  Not sure of what technique to get started with.  Any ideas?  Recurs
at No comments:

SQL Server retrieval unit

SQLServerCentral » Latest topics
SQL Server retrieval unit
I'm having a technical discussion with a colleague and he keeps insisting that the smallest "retrieval unit" for SQL Server is 64k. Silly me, I thought if I asked for 20 bytes I'd get back 20 bytes. I understand it has to access a page, find the row etc b
at No comments:

equality taken into account

SQLServerCentral » Latest topics
equality taken into account
[url=http://www.malkocompetition.dk/sites/default/files/Patriots-vs-Lions-Live-Stream-NFL-ScoresOnline-25-August-2017-TV-Guide.pdf]Patriots vs Lions Live Streaming[/url]
at No comments:

Dynamic SQL and TempTables

SQLServerCentral » Latest topics
Dynamic SQL and TempTables
Comments posted to this topic are about the item [B]Dynamic SQL and TempTables[/B]
at No comments:

When you migrate a database to the same SQL build, but a new environment, post migration tasks?

SQLServerCentral » Latest topics
When you migrate a database to the same SQL build, but a new environment, post migration tasks?
Hello everyone,

I was curious as to peoples take on the following...

Lets say you have to move a database to a different network and domain, it could even be an Azure Virtual Machine in the cloud. Now normally, you'd migrate a database t
at No comments:

Need help adding dates and null values to results

SQLServerCentral » Latest topics
Need help adding dates and null values to results
Hello Everyone,
     I have a table that stores invoice information.  Now, invoices are not entered every day so there may be a 1 day gap between invoices.

     I need to write a stored p
at No comments:

Delete Extended Events file

SQLServerCentral » Latest topics
Delete Extended Events file
Is there any way to delete the xel file once I no longer need it without having to use something other than SSMS?
I won't have access to the server other than sql, and I don't want to keep creating new files every time that would last for the eternity
at No comments:

Same blog, new home

SQLblog.com - The SQL Server blog spot on the web
Same blog, new home

The historical content of my blog is also available on www.sqlbi.com/blog/, and future posts will appear there first.

I will continue to keep this blog (on sqlblog.com) updated when I will publish new posts, including a link to the full post published on SQLBI.

You can register the new blog RSS feed or register by mail, too (the feed includes both blogs and articles published on SQLBI).

at No comments:

Azure Flash Friday: Aug 25, 2017

Azure Flash Friday
Azure Flash Friday: Aug 25, 2017
at No comments:

SQLCMD Mode; Run all SQL files in a directory

SQLServerCentral » Latest topics
SQLCMD Mode; Run all SQL files in a directory
Comments posted to this topic are about the item [B]SQLCMD Mode; Run all SQL files in a directory[/B]
at No comments:

PowerShell ROBOCOPY not working in agent job step in SQL Server 2016

SQLServerCentral » Latest topics
PowerShell ROBOCOPY not working in agent job step in SQL Server 2016
We have been running the following PowerShell command in a SQL Server Agent job step without issue for many months in our other instances, to mirror database backup files to a separate location on another server share:

ROBOCOPY "\\Server1\BackupS
at No comments:

The Career Bucket List

SQLServerCentral » Latest topics
The Career Bucket List
Comments posted to this topic are about the item [B]The Career Bucket List[/B]
at No comments:

Creating View with More Records than original table

SQLServerCentral » Latest topics
Creating View with More Records than original table
I am not sure if this can be done but I would like to create a view (or 2nd option a new table that gets updated each night).

I have a table that is updated each night from a com
at No comments:

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

Transaction Logs in Status 2 for no apparent reason

SQLServerCentral » Latest topics
Transaction Logs in Status 2 for no apparent reason
I've got a SQL 2012 Server in a 3 Node Always On Configuration. Version: 11.0.5058, so SP2. We are finding 2 of the (31) databases regularly have their transaction logs blow out, with all VLFs
at No comments:

SQLCMD Mode; Run all SQL files in a directory

SQLServerCentral » Latest topics
SQLCMD Mode; Run all SQL files in a directory
Comments posted to this topic are about the item [B]SQLCMD Mode; Run all SQL files in a directory[/B]
at No comments:

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

SQLServerCentral.com Articles
Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.

at No comments:
Subscribe to: Posts (Atom)