Exceptional DBA

Technical Article

RE: I post wrong place, no one answer??

  • Reply

Thank you for the reply, in QA I am not use default setting(grid), so my QA return fast from EM, my developers not using EM also, but they had slow process try show me how slow is, and when I remote logon box, and it is fast from EM then from my client machine(which far […]


Technical Article

RE: Closing bal prev month / opening bal next month

  • Reply

Thanks Keith, I've tried this syntax in AS on the calculated cell: with member measures.Amt as ' sum( { PeriodsToDate(Time.Year, Time.Month.currentmember) } , measures.currentmember ) ' select { [measures].measureslevel.allmembers } on columns, { [Time].[Month].members } on rows from Test but get a syntax error: 'expecting SELECT, near: 'sum({PeriodsToDate(Time.Year, Time.Month.currentmember)}.......... The member is called 'OPENING BALANCE' […]


Technical Article


  • Reply

Select ColName From TableName Where [IdentityColName] = @@Identity ColName is the name of the column with the GUID and IdentityColName is your IdentityCOlumn. Cheers, Crispin Something as incredibly simple as binary still gives you too many options


Technical Article

RE: Geometrical data

  • Reply

Hi Dale, quote: Check this out. I found this on Citeseer. Used that site a lot for my Masters: thanks again! Seems to be a good site. Now I only need a good pocket dictionary Cheers, Frank


Technical Article

RE: Locate and replace

  • Reply

well , it's not working at all, i'm trying this: and it takes too long, don't know any idea??? declare @areadesc char(50) DECLARE csrSites CURSOR FOR SELECT area_code FROM billable_temp select @count=(select count(*) from billable_temp) Open csrSites FETCH NEXT FROM csrSites INTO @areacode WHILE @count > 0 select @areadesc=(select distinct areadesc from rates1 where areacode=@areacode) […]


Technical Article

RE: Login fails

  • Reply

Okay, if you've got other SQL Server logins connecting successfully, have you verified the sa password? For instance, can you terminal into the server and login? You'll avoid IPSec or anything else that might be a barrier because you'll be using shared memory. If you don't have other SQL Server logins connecting successfully, verify mixed, […]


1 reads


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