Tabular Model

Technical Article

RE: configuration for server

  • Reply

print 'Free Space' print '----------' exec master.dbo.xp_fixeddrives print 'Memory' print '------' exec master.dbo.xp_msver print 'Database Configuration' print '----------------------' exec master.dbo.sp_configure print'DB Size' print'-------' exec master.dbo.sp_databases print 'Linked Servers' print '--------------' exec master.dbo.sp_helplinkedsrvloginprint 'Windows info' print '------------' exec master.dbo.sp_server_info


Technical Article

RE: SQL to trigger an ASP file

  • Reply

Triggers do not monitor data.  They only run on table for an insert, update, or delete transaction.Can you explain what the table holds?Is it a table that holds a single row of configuration data or is it the "timetoSend" column hold values for multiple rows?


Technical Article

Connection Problem To Oracle Database

  • Topic

Please advice. I run a SQL3K SP3 on a WIN2K SP4 in an active/active Failover cluster.Linked server was created to an Oracle databse using Oracle 9i client and MS OLEDB Provider. The error below was generated when running a query from QA. Error 7399 OLE DB Provider MSDAORA  reported an error OLE DB error trace OLE/DB […]


1 reads

Technical Article

There HAS to be an easy way to get started...

  • Topic

I'm going to be writing an app in C# that stores scanned invoice images in a database along with some other information about the invoices in the record.  If there were no images involved, I'd already be halfway done, but I just don't know how to work with them yet.  I've been working with […]


Technical Article

RE: How to Execute quary in store procedure

  • Reply

But why do you want to create the temp table in two steps, is there any specific reason, you can as well create it with the CREATE table #mytable (column1 datatype ) syntax directly right? Sorry if I am missing anything here. Well if you are passing the table structure as input parameter to the […]


Technical Article

RE: Sum Aggregate

  • Reply

SELECT YearNumber, MonthNumber, SUM(Occurances) AS CountOfData FROM (select YEAR(DateField) AS YearNumber, MONTH(DateField) AS MonthNumber, Count(datacount) As Occurances FROM datatable GROUP BY SQLDate)Dates GROUP BY YearNumber, MonthNumber Order By YearNumber, MonthNumber This should give you what you are looking for.


Technical Article

RE: Review of Lumigent Log Explorer v3

  • Reply

Having used Log Explorer for over 3 years, I've found some additional uses other than restoring data:Exporting the transaction log records to a SQL table and running queries to determine who and when data was modifiedThe Load Analysis feature particularly the information on page splits is interesting. I've been unable to find any other method […]


Technical Article

RE: Connections: How many is too many?

  • Reply

We are running SQL Server 2000.I do not see "The working thread limit of 255 has been reached" in SQL Server error log.So, what you are saying is my performance problems are probably related to something else than the 350 connections and that changing the "max worker thread" would be a bad idea?Is 350 or […]


Technical Article

RE: Encryption

  • Reply

Are you sending encrypted data or looking to encrypt the data stream? SSL will encrypt the stream, but the data will be text in the server. If you encrypt on the client, then you don't need to owrry about the stream.



Flyway Desktop Projects for My PoC


In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023


Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 


When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs


Database copies (cross environment) and sizing strategies for 2019

By MyDoggieJessie

I'm sure this has been asked many, many, many times and hoping several optimal...

TSQL to determine status of subscription reinitialization

By ratbak

How do I determine the initialization status of a subscription with T-SQL -- i.e,...


By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers