RE: Storing Anything and Everything - Any Ideas?
The lists of fields aren't so much pre-defined as decided on once per user, then left alone for that user. I like the idea about the different data types in different columns - thanks!!
2004-03-11
trace flags
2004-02-06
RE: Question of the Day for 05 Feb 2004
Erm, make that 10! PS, love those helpful messages that have just appeared on the left of the posting window - "Banner turned off on purpose" and "This banner not working right either!"Doesn't make me feel too bad about an intranet login page I forgot to change which happily informs the users "You are not […]
2004-02-05
2004-02-04
RE: need help
In that case try: Select Count(orderNo) as COrders, Month as theMonth into #TempCustOrders From Orders Where CustId = @CustId Group by Month Select t.COrders as CustOrders, Count(OrderNo) as TotalMonthOrders, Month From Orders inner Join #TempCustOrders t on t.theMonth = Month Group by t.COrders, Month Drop Table #TempCustOrders
2003-12-18
RE: Free OLEDB Provider for DB2
Not sure there is one. Steve Jones sjones@sqlservercentral.com http://www.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/ www.dkranch.net
2003-11-20
RE: Pet Peeves
Yeah, he's a character alright! Seems like an incredibly inteligent guy, and he doesn't give a crap for what people think about him. Never realized until today quite how prolific he is...
2003-09-12
RE: table
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Customers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Customers] GO
2003-08-27
RE: Saving Global Variables
Thanks a lot, using a little bit of your suggestion I have managed a workaround. This involves two activeX script tasks. The first loads the variables and is run before any other tasks. The second saves them and is run after every other task. It seems to work very well. This is the code in […]
2003-08-27
RE: Task Pad view in Enterprise Manager
I wish. I have asked this question before and have gotten no good leads. I have heard though, that once you select it to be the view EM will remember it. I have mixed results with this method, but sometimes it does remember the view. Chris Doesn't know nuthin about nuthin, but don't tell nobody. […]
2003-08-19
1 reads
Blogs
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
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...
Forums
Database copies (cross environment) and sizing strategies for 2019
I'm sure this has been asked many, many, many times and hoping several optimal...
TSQL to determine status of subscription reinitialization
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
migration
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Ask SSC