|
|
Marlonr
Marlonr
 |
|
Stories submitted by Marlonr
|
|
submitted by
Marlonr
1 month, 25 days ago dbalink.wordpress.com — I was having a problem accessing a folder via an extended procedure. The extended procedure accepts a DirectoryInfo variable (File Path) and it returns the File Size and File Count within the folder (much like right-clicking a folder and choosing the “Properties” from the context menu). I need the info to monitor the file size of specific folders for a SSRS report. read more...
add a comment
|
category:  Database | Views: 3
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
1 month, 28 days ago dbalink.wordpress.com — This is a cool whitepaper (sponsored by Quest Software) that maps out what to expect in the future in the DBA field. read more...
add a comment
|
category: Database | Views: 9
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
1 month, 30 days ago dbalink.wordpress.com — DBA’s use index to optimize the performance of their databases. They either create or drop indexes according to the current needs of their system. Using the Dynamic Management Views (DMV) and the other related catalog views, DBA’s are able to analyze the statistics for indexes. read more...
add a comment
|
category: Database | Views: 5
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
2 months, 3 days ago dbalink.wordpress.com — In this post let’s move a data file from its default location to another location. I have created a database I called “Test” for the demo. First let’s just check where the data file is currently stored: read more...
add a comment
|
category: Database | Views: 4
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
2 months, 7 days ago dbalink.wordpress.com — So finally the clamor (I’m exaggerating) for SQL Server 2005 SP3 is finally heard! Four days ago SQL Server 2005 SP3 CTP has been announced. An earlier announcement gave us a heads up. read more...
add a comment
|
category: Database | Views: 6
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
2 months, 10 days ago dbalink.wordpress.com — This question posted on StackOverflow.com caught my attention. This is a common data requirement specially in Data Analysis. It goes like this: read more...
add a comment
|
category: Database | Views: 5
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
2 months, 12 days ago dbalink.wordpress.com — Now, for the very first time ever, a reliable and authoritative SQL Server Training Resource has come to life. This is some serious stuff. A heaven-sent goodness to the SQL Server Community! read more...
add a comment
|
category: Database | Views: 5
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
2 months, 15 days ago dbalink.wordpress.com — Sometimes we need to install a dynamic link library to take advantage of extended stored procedure in SQL Server. So you have installed it through the Extended Stored Procedure GUI. You double checked that the dll exists in the MSSQL\Binn directory. But then when you tried to execute the procedure you received this Error:
Cannot load the DLL C:\Microsoft SQL Server\MSSQL\Binn\dllname.dll, or one of the DLLs it references. read more...
add a comment
|
category: Database | Views: 1
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
2 months, 16 days ago dbalink.wordpress.com — Okay, these are at least the two ways you can query the Metadata in SQL Server (TSQL). The first one is like what I’ve already shown here, which has the following TSQL cod read more...
add a comment
|
category: Database | Views: 0
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
2 months, 16 days ago dbalink.wordpress.com — I previously posted about finding user table basic information. In this post, let us use a handy TSQL to find all the Primary Key Constraints and the tables they are associated with. read more...
add a comment
|
category: Database | Views: 2
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
2 months, 16 days ago dbalink.wordpress.com — Browsing stackoverflow for SQL Server tags has now become a habit that I do on my free time. For some reason I missed this interesting post about Hidden Features in SQL Server. read more...
add a comment
|
category: Database | Views: 11
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
2 months, 21 days ago dbalink.wordpress.com — One of the most common business requirements for SQL Server Reporting Services is that an SSRS Report should be dynamic. Dynamic in a sense that the report consumer can query the report in a variety of ways. In this post, I will demonstrate how you can add a parameter value “ALL” to return all of the desired result. read more...
add a comment
|
category: Database | Views: 21
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
3 months, 14 days ago dbalink.wordpress.com — Brad’s Sure Guide to SQL Server 2008: The Top 10 New Feature for DBAs
This is a Free eBook from Redgate! Grab it now! read more...
add a comment
|
category: Database | Views: 7
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads by The Lounge
|