Geeks With Blogs

News Copyright © 2008-2016 Paula DiTallo
Ask Paula! ...bringing you notes from the field...
Open up a windows command shell. Type in: shutdown -r -t360 -m servname.onyourdomain.comIf you are looking for more information about this, check out this linkhttps://technet.microso... ......

This took me longer than it should have to figure out. In just a few simple steps, all those emails can easily be dealt with in sets.Go to the folder you are interested in.click the top check box--or the "select all" . You'll see a text line appearing just above the trash can icon that says something like "All 999 conversations on this page are selected." ......

If you have a very large data base (VLDB) a select count(*) can take a long time to resolve. Try this statement as an alternative:USE YourDatabasename;SELECT s.name AS 'SchemaName' ,o.name AS 'TableName' ,SUM(p.row_count) AS 'RowCount'FROM sys.dm_db_partition_stats p JOIN sys.objects o ON o.object_id = p.object_id JOIN sys.schemas s ON o.schema_id = ......

This will locate specific text within an object on a given database. In this case, it will find all views, stored procs which have the text string "Department" somewhere in the body.use [databaseInstance]goSELECT DISTINCT o.name AS Object_Name, o.type_descFROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition ......

The most likely reason is that your profile has not been configured, or you are using an incorrect name under the @profile_name parameter. To determine your profile settings, use this query:SELECT [profile_id] ,[name] ,[description] ,[last_mod_datetime] ,[last_mod_user] FROM [msdb].[dbo].[sysmail_profile] If after you have checked the results of this ......

This sql script will start an agent job on a remote server. If you're running this as a step in another agent job, keep in mind that the job you are running it from will be determined to be successful, even if the remote job fails--as this is an asynchronous kick off only.declare @returnCode int declare @JobName varchar(300) declare @ServerName varchar(200) ......

You will need to enable the feature first.Follow these steps:EXEC sp_configure 'show advanced options', 1GO-- this updates whatever the currently configured value for advanced optionsRECONFIGUREGO-- Now enable the command shellEXEC sp_configure 'xp_cmdshell', 1GO--update the currently configured value with xp_cmdshell setting update.RECONFIGUREGO ......

If you are using the SSMS GUI, you may not be aware that behind the scenes, you are really issuing an ALTER DATABSE command. It is likely that another process (or processes) were accessing the database you want to take offline.If you're a DBA, or have sysadmin privileges, issue an sp_who2 command -- looking for the ALTER DATABSE process logged to you. ......

Think of this as a lightweight alternative to SQL profiler. Under the hood of SQL profiler, there exists SQL Trace -- which provides a collection of stored procedures to generate trace info. Cut and paste the t-script below to see how it works.-- Pay attention to what the server settings for traces look like first:select * from sys.tracesgo-- you are ......

These general statements will get you the information that you're looking for:SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, COLUMN_TEXTFROM "SYSIBM"."SQLCOLUMNS"WHERE TABLE_SCHEM = 'YourSchema' AND TABLE_NAME = 'YourTableName'This will get you the definitions of the columns:SELECTt.table_schema as Library,t.table_name,t.tabl... ......

Go to the server your are interested in gathering the information from, then issue this statement:WITH LastRestoresOnServer AS(SELECT sysdb.[name] as dbName, sysdb.[create_date], sysdb.[compatibility_level], sysdb.[collation_name], r.*, ROW_NUMBER() OVER (PARTITION BY sysDb.Name ORDER BY r.[restore_date] DESC) as RNFROM master.sys.databases sysdbLEFT ......

You were probably trying to do a comparison between 2 databases with different collation settings on a WHERE clause or on a join. Here's how you would do the comparison with a JOIN: Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Select * from source db1.schema.table1 as t1 join source db2.schema.table2 as t2 on t1.col1 collate ......

This pattern works well:USE [yourDatabase] GO IF OBJECT_ID('ThisSproc', 'P') IS NOT NULL DROP PROCEDURE ThisSproc; GO CREATE PROCEDURE ThisSproc @PersonId INT, @NewMoneyCollected MONEY = 0 AS BEGIN BEGIN TRY BEGIN TRANSACTION; UPDATE OrganizationTripFunding SET Balance = MoneyCollectedAllYear + @NewMoneyCollected WHERE PersonId = @PersonID; COMMIT TRANSACTION; ......

The full error message reads as "Failed to deploy project. For more information, query the operation_messages view for the operation identifier '39212'. (Microsoft SQL Server, Error: 27203)In a nutshell, the most common reason for this is the latency between SQL Server logging the deployment operation within the SSIS catalog database and the stored ......

If you aren't able to install from the Help\Install New Software menu, it is probably because the zip file doesn't have the content.jar/artifacts.jar needed to do so. You will need to navigate to where you've installed Eclipse, then follow these steps: 1. Navigate to the Dropin drectory2. Create a new subdirectory (folder).3. Expand the zip file to ......

This usually happens when you restore a database. For example, you restore a copy of production database X to your QA server. In essence, you have overwritten the user info of that specific database with what exists in production. This creates an orphan user -- where you have no login associated with a user in that database on a server that once associated ......

There are several reasons for this. The most common reason is that the account you are using while logged into mssql through ssms does not have access to the drive definition you are using as your source. Network drives are a good example of an access conflict.Assuming you have access to the drive, try redirecting the network drive to a local drive ......

In SSMS, there's a Generate Script utility (read: only available under version 2008 and up) . Here are the steps you would need to take to make use of the utility: Right click on the database you're interested in and go to Tasks -> Generate ScriptsSelect the tables and/or any other objects you'd like in order to get them into the script.Navigate ......

Here's an example using forfiles to scan your storage. This command line will look for files over 200mb on the C:\ drive after 1/1/2014. forfiles /P C:\ /M *.* /S /D +"01/01/2014" /C "cmd /c if @fsize gtr 209715200 echo @path @fsize @fdate @ftime"For more information, check out Microsoft's examples and syntax page:http://technet.microso... ......

Try using count_big(*) instead-- this is defined as bigint instead of int.In this example, I am looking for how many 100s of millions of rows exist by product type where each row is roughly 300 bytes wide to ultimately obtain how many gigabytes of data I need to provision.select x.ProductType, count_big(*) as ProdCount, (count_big(*)*300) as TotalBytes, ......

Click on the App Button (aka: "Drawer" ) -- That's the key with the multiple squares, click on menu , select view type, select alphabetical grid.


Open up an MSDOS command window. Type :net fileThe id, path, user name, loc# for the file will show up in a text list. Once you find the file you want unlock, you'll need to remember the id. To unlock the file, go back to the MSDOS command window. Type:net file 99/close (where 99 = file id)On a windows server there are 2 other ways:1. From an MSDOS ......

We've all been there-- like -- where's that offline htm file i bothered to save last week ... oh I think it was blue something... or was it something blue? find ../ -name '*blue*.htm*' -print If you want to keep it in an output file to sort through later while you do something else: find ../ -name '*blue*.htm*' -print > $HOME/ foundBlue.txt ......


Try holding down the Menu and Selector (push-button circle in the center) down at the same time for at least 2 seconds.


The simplest answer is because the iPOD software detects that it is unsafe (read: data loss) for your iPOD, Computer or both if you were to disconnect the cable without ejecting the device first.Here's what to do:On the Mac-- Click on the Finder icon Pick the iPOD icon.Navigate to the File menu--select Eject iPOD On a Windows OpSys device-- On the Start ......

Copyright © Paula DiTallo | Powered by: GeeksWithBlogs.net | Join free