In this post , I showed a way to generate 8 characters random password If you have table with data and add a column for password and want to fill that column with random passwords , you can use this approach. I have seen the usage of a function that generates...(read more)
So, yet another SQLBits finished, and judging by the feedback we got it was the best yet. Certainly we had our highest ever attendance and the sponsors all seemed very happy (which is important because, after all, they're the ones paying for it); we've also had a number of very kind emails thanking us too. Now for a few months of peace and quiet before we start planning for the next one, which I suppose will be sometime in the autumn. Any suggestions on w...Full Article.
Hmm, you wait for years for commercial tools for monitoring Analysis Services (the only one I'd ever seen before was Companion for Analysis Services from SQLMinds) and then two come out at once. One of these tools I'll be blogging about towards the end of this week, hopefully - I've had a sneak preview and it looks very cool - but today I found out the following from SQL Solutions:
- OLAP...Full Article.
In this post splitting-csv-to-columns I showed how to split delimited data into multiple columns
Simon in his post 1 Use IN ...Full Article.
In the post Import/Export to Excel, I showed how to export data to EXCEL
The problem that most users find it is it wont include column names in the file and file should exists already with headings
This procedure would solve that problem
If you want to know the datatype or length of a column , you can query on the system table syscolumns or system view INFORMATION_SCHEMA.COLUMNS But you dont need to query on system objects if you use SQL_VARIANT_PROPERTY function Example SELECT TOP 1...(read more)
read more)
How do I view the script of the DDL triggers? The answer is not sp_helptext 'DDL trigger' Because DDL triggers are defined at database / server level and not at any table level So they are not stored in a system objects like sys.objects and the...(read more)
read more)
read more)
read more)
read more)
This is used to set the number of rows affected for DML Declare @test table ( number int ) set rowcount 1 insert into @test select 11 union all select 10 set rowcount 0 select number from @test The above inserts only one row to the table variable @test...(read more)
read more)
read more)
BI Survey. It being that time of year, I got the latest edition - the BI Survey 8 - last week along with an email encouraging me to blog about it, and who am I to refuse a request to blog about something as fascinating as this? It's a whopping 489 pages long so I can't even begin to summarise it, but there a...Full Article.
BI Survey. It being that time of year, I got the latest edition - the BI Survey 8 - last week along with an email encouraging me to blog about it, and who am I to refuse a request to blog about something as fascinating as this? It's a whopping 489 pages long so I can't even begin to summarise it, but there a...Full Article.
Here's something that had me stumped for quite a long time earlier this week.
I'm doing some performance tuning work for a customer at the moment, and following my usual approach I took a test query, cleared the cache, ran it and noted how long it ran for and what I saw in Profiler and MDX Studio. However this time I saw some strange things happening: I'd run the same query on a cold cache more than once and the query times would differ by anything up to a minute; even more confusing, the ...Full Article.
Earlier this week Greg Galloway sent me an email about some new code he'd added to the Analysis Services Stored Procedure Project to clear the Windows system file cache:
http://asstoredprocedures.codeplex.com/Wiki/View.aspx?title=FileSystemCacheFull Article.