SQLServerCentral » Latest topics
Mathematics/Algorithms in SQL
All,
I am looking for some article which explain what are all the mathematics concepts and algorithms used in SQL.
Monday, December 4, 2017
SSMS 17.3 Start Powershell give s error - No SQL Server cmdlets found on this computer
SQLServerCentral » Latest topics
SSMS 17.3 Start Powershell give s error - No SQL Server cmdlets found on this computer
This is a Win 10 desktop and I've installed the sqlserver module via install-module sqlserver -force. I can import it into a Powershell session and navigate the SQLSERVER: drive but SSMS 17.3 doesn't see the module. Is there something else I need to do.
sql injection help
SQLServerCentral » Latest topics
sql injection help
Hello All,
I have an unusual request today.
My company has a very old Access VBA application, this application uses inline sql to read, insert ect.. into our Azure DB. I am not sure what version this DB is.
This inline sql tha
I have an unusual request today.
My company has a very old Access VBA application, this application uses inline sql to read, insert ect.. into our Azure DB. I am not sure what version this DB is.
This inline sql tha
A Christmas Bug
SQLServerCentral » Latest topics
A Christmas Bug
Comments posted to this topic are about the item [B]A Christmas Bug[/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
General question on tuning
SQLServerCentral » Latest topics
General question on tuning
Hi All
Need some suggestions and clarity. Its a general basic question on Query tuning.
Is there any difference(s) when it comes to query tuning of a Azure database and OnPremise database?
In one of our env, they are looking for so
Need some suggestions and clarity. Its a general basic question on Query tuning.
Is there any difference(s) when it comes to query tuning of a Azure database and OnPremise database?
In one of our env, they are looking for so
Need vertical table as horizontal table in SQL
SQLServerCentral » Latest topics
Need vertical table as horizontal table in SQL
Hi Team,
can you please help me to get
create table company
(
name varchar(100)
)
insert into company
select 'IBM'
UNION ALL
select 'Goolge'
UNION ALL
select 'Microsoft'
UNION ALL
select 'app
can you please help me to get
create table company
(
name varchar(100)
)
insert into company
select 'IBM'
UNION ALL
select 'Goolge'
UNION ALL
select 'Microsoft'
UNION ALL
select 'app
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
PASS SQL Saturday #687 Slovenia 2017 Sponsors Showcase
SQLblog.com - The SQL Server blog spot on the web
PASS SQL Saturday #687 Slovenia 2017 Sponsors Showcase
Please take a minute and check this brief introduction of our wonderful gold, silver, and bronze sponsors.
Comtrade is a dynamic and well established technology group, with a 25-year track record of innovation and steady development of some of the world’s most advanced software. Founded as a software engineering and services company, Comtrade has evolved into a software product business, a services company and a systems integrator. With world-class infrastructure and campuses in 10 countries, Comtrade operates as a holding company for vibrant businesses, such as Comtrade Gaming. Created in 2001, Comtrade Gaming is leading the digitalization of the gaming industry with its high-end software and technology. With 4 technology centers and over 200 employees, Comtrade Gaming's strengths are the development of open platforms, systems and services for land-based and online gaming sectors. The company's product portfolio includes server-based systems, mobile gaming products and igaming platforms that cater to regulators, operators and vendors.
Kompas Xnet is one of the leading IT companies in Slovenia, founded 20 years ago. As a Microsoft Certified Partner we focus primarily on Microsoft technologies to provide customized solutions for the most demanding business needs. As a leading Microsoft learning partner in the region, our training center offer MOCs and other technical courses for IT professionals at the highest level, as well as basic and advanced workshops for end-users. Kompas Xnet is also the Slovenian LLPA representative of the best IT training centers in the EMEA region.
As a global IT company with thirty years of experience, COMPAREX is one of the world’s leading IT service providers and no. 1 software license Management Company in the EMEA markets. COMPAREX develops innovative services that support management and leverage software products, leading to an overall improvement of workforce productivity. COMPAREX serves corporate customers spanning from small businesses to large international corporations as well as public institutions – supporting every customer during their digital journey towards productivity optimization. The portfolio has a solid foundation in license management, software procurement and cloud services. Substantial professional and managed services complete the portfolio to support customers with services tailored to their business demands. With the statement “By Your Side in a Digital World”, COMPAREX underlines its goal to inspire customers with possibilities and opportunities for their digital transformation, by addressing key customer priorities.
Thank you for your attention!
Call sp from a Case statement
SQLServerCentral » Latest topics
Call sp from a Case statement
Hi,
I am trying to execute a Stored Procedure after two other jobs in the schedule have completed successfully, so I am looking to a specific filed (DW_CREATED_
I am trying to execute a Stored Procedure after two other jobs in the schedule have completed successfully, so I am looking to a specific filed (DW_CREATED_
Import 2014 Registered Servers
SQLServerCentral » Latest topics
Import 2014 Registered Servers
My dev box was replaced on Friday, as SQL 2016/2017 would not install on Win7.
I have just finished installing SQL 2017, and would like to get my extensive list of Registered Servers back.
However, according to
I have just finished installing SQL 2017, and would like to get my extensive list of Registered Servers back.
However, according to
Tempdb Error
SQLServerCentral » Latest topics
Tempdb Error
Hi All,
I have 3 ndf files for Tempdb and each one is now grown to 110+ GB. i.e total 330 GB+
I have tried
[code language="sql"]use tempdb
go
DBCC FREEPROC
I have 3 ndf files for Tempdb and each one is now grown to 110+ GB. i.e total 330 GB+
I have tried
[code language="sql"]use tempdb
go
DBCC FREEPROC
Read TXT File - problem with importing from flat file source ssis
SQLServerCentral » Latest topics
Read TXT File - problem with importing from flat file source ssis
hi Guys,
I have txt file where i have 14 million rows from Qlikview and SAP exported.
Now i want to import in into SQL Server Database.
I have txt file where i have 14 million rows from Qlikview and SAP exported.
Now i want to import in into SQL Server Database.
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.
Subscribe to:
Posts (Atom)